You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin1_General_100_CI_AI collation. Each database has an Orders table that has the following definition:

You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?

Question

You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin1_General_100_CI_AI collation. Each database has an Orders table that has the following definition:

You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?

Accepted Answer

B. Option B

Answer

A. Option A

Answer

C. Option C

Answer

D. Option D

You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the…

Question

Exhibits

Options

How the community answered

Community Discussion