In collation name meaning of AI and
AS
AI: Ascent
insensitive
AS: Ascent
sensitive
Example of ascent insensitive comparison in sql server
IF 'a' = 'à' COLLATE
Latin1_General_CI_AI
SELECT 'Ascent
insensitive'
ELSE
SELECT 'Ascent sensitive'
Output: Ascent insensitive
Example of ascent insensitive comparison in sql server
IF 'a' = 'à' COLLATE
Latin1_General_CI_AS
SELECT 'Ascent
insensitive'
ELSE
SELECT 'Ascent sensitive'
Output: Ascent sensitive
What is non clustered index in sql server
When sql server is able to use indexes and when not
How to use database engine tuning advisor to get recommendations in sql server
Effect of collation in indexing in sql server.
Write sql queries in set based approach sql server
Sql server best practices for stored procedure
What is Adhoc query in sql server: Cached Query Plan
Subquery vs inner join which one is better in sql server
What is non clustered index in sql server
When sql server is able to use indexes and when not
How to use database engine tuning advisor to get recommendations in sql server
Effect of collation in indexing in sql server.
Write sql queries in set based approach sql server
Sql server best practices for stored procedure
What is Adhoc query in sql server: Cached Query Plan
Subquery vs inner join which one is better in sql server
No comments:
Post a Comment