You plan to add a new column named SmallKey to the Sales.Product table that will be used in a
unique constraint. You are required to ensure that the following information is applied when adding the
new column:
‘a1’ and ‘A1’ are treated as different values
‘a’ and ‘A’ sort before ‘b’ and ‘B’ in an ORDER BY clause You need to select the collation that meets the requirements for the new column. Which collation should you select?
A.
Latin1_General_BIN
B.
SQL_Latin1_General_CP1_CI_AI
C.
SQL_Latin1_General_CP1_CI_AS
D.
SQL_Latin1_General_CP1_CS_AS