Which Transact-SQL statement should you use?

You are developing an application that uses data residing in two databases named Inventory and Accounting on a single Microsoft SQL Server 2012 server.
You plan to provide a record set from tables in the Inventory database. You write the following query:

You need to create this query as a permanent database object that can be joined to other queries. The other queries will be run from the Accounting database. Neither database allows cross-database ownership.
Which Transact-SQL statement should you use?
A.

B.

C.

D.

E.

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.