You administer a Microsoft SQL Server 2008 R2 instance that contains two databases
named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the
SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the
SQL_Latin1_General_CP1_CS_AS collation.
You need to write a query that returns all customers having the same name in each
database. You also need to ensure that the query is not case-sensitive.
Which Transact-SQL query should you use?
A.
Option A
B.
Option B
C.
Option C
D.
Option D