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