What does it mean by the As in the default collation SQL_Latin1_General_CP1_CI_AS?
The collate clause is used for case sensitive and case insensitive searches in the columns of the SQL server. There are two types of collate clause present: SQL_Latin1_General_CP1_CS_AS for case sensitive. SQL_Latin1_General_CP1_CI_AS for case insensitive. What is SQL_Latin1_General_CP1_CI_AS collation? The collate clause is used for case sensitive and case insensitive searches in the columns of the SQL server. There are …