Which Transact-SQL query should you use?

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?

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



Leave a Reply 0

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