You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. Domain.com is using the following to
join two tables on a column called CK_Cmn.

SELECT P.*, PD.*FROM Products
AS PINNER JOIN Products AS PD ON PD.CK_Cmn = PD.CK_Cmn

However, when you run the search you received the following error:

"Msg 468, Level 16, State 9, Line 17Cannot resolve the collation conflict between
‘SQL_Latin1_General_CP1_CS_AS’ and ‘SQL_Latin1_General_CP1_CI_AS’ in the equal to
operation."

You need to ensure that you can change the ON clause of the search to perform a join. What
should you do?

A.
You should consider adding the following:
CK_Cmn) = UPPER(P.CK_Cmn)

B.
You should consider adding the following:
CK_Cmn) = TRIM(P.CK_Cmn)

C.
You should consider adding the following:
CK_Cmn= P.CK_Cmn COLLATE SQL_Latin1_General_CP1_CI_AS

D.
You should consider adding the following:
CK_Cmn= P.CK_Cmn COLLATE SQL_Latin1_General_CP1_CS_AS

Explanation:
See Difference!
CK_Cmn= P.CK_Cmn COLLATE SQL_Latin1_General_CP1_CI_AS
CK_Cmn= P.CK_Cmn COLLATE SQL_Latin1_General_CP1_CS_AS