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?
A.
Option A
B.
Option B
C.
Option C
D.
Option D