70-433 · Question #95
Your server collation is SQL_Latin1_General_CP1_CI_AS. You have a database named Contoso that has a collation setting of SQL_Scandinavian_Cp850_CI_AS. You create and populate a temporary table…
Sign in or unlock 70-433 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
Question
Your server collation is SQL_Latin1_General_CP1_CI_AS. You have a database named Contoso that has a collation setting of SQL_Scandinavian_Cp850_CI_AS. You create and populate a temporary table #Person from table dbo.Person in Contoso using the following statements:
use MyDB; CREATE TABLE #Person (LastName nchar(128)); INSERT INTO #Person SELECT LastName FROM dbo.Person; You then run the following command:
SELECT * FROM dbo.Person a JOIN #Person b ON a.LastName = b.LastName; This command returns the following error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Scandinavian_Cp850_CI_AS" in the equal to operation. You need to resolve the collation conflict. Which Transact-SQL statement should you use?
Options
- ACREATE TABLE #Person (LastName nvarchar(128) SPARSE);
- BCREATE TABLE #Person (LastName nvarchar(128)
- CCREATE TABLE #Person (LastName nvarchar(128)
- DCREATE TABLE tmpPerson (LastName nvarchar(128)
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.