You need to modify the ON clause of the query to successfully perform a case-sensitive join

You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned:
“Msg 468, Level 16, State 9, Line 17
Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS’ and
‘SQL_Latin1_General_CP1_CI_AS’ in the equal to operation.”
You need to modify the ON clause of the query to successfully perform a case-sensitive join.
What should you do?

You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned:
“Msg 468, Level 16, State 9, Line 17
Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS’ and
‘SQL_Latin1_General_CP1_CI_AS’ in the equal to operation.”
You need to modify the ON clause of the query to successfully perform a case-sensitive join.
What should you do?

A.
ON UPPER(i.CompanyName) = UPPER(s.CompanyName)

B.
ON LOWER(i.CompanyName) = LOWER(s.CompanyName)

C.
ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CI_AS

D.
ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CS_AS



Leave a Reply 0

Your email address will not be published. Required fields are marked *