PdfPrep.com

Which three Transact-SQL segments should you use to develop the solution?

DRAG DROP

You develop a database application for Microsoft SQL Server 2012 and Microsoft Azure SQL Database.

You create a table named Purchasing.vVendorWithAddresses as shown in the following table.

You write the following Transact-SQL (Line numbers are included for reference only.) 01 CREATE PROCEDURE

You need to add Transact-SQL statements at line 08 to ensure that GetVendorInStateNeighbors returns the names of vendors that are located in all states where the vendor specified in the @vendorname parameter has a location.

Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.

Answer:

Explanation:

The IN statement determines whether a specified value matches any value in a subquery or a list.

Incorrect: The EXISTS command specifies a subquery to test for the existence of rows.

References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact­sql?view=sql-server-2017

Exit mobile version