Ascent sensitive and insensitive collation example in sql server

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