PrepAway - Latest Free Exam Questions & Answers

You need to ensure that up_customers returns rows when …

You have a SQL Server 2012 database named Database1.
Database1 has a table named Customers. Customers contains more than 1 million rows. The database has a
stored procedure that was created by using the following script:

You need to ensure that up_customers returns rows when the following statement is executed:
EXECUTE up_customers’1,2,3,4,5′;
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Update @CustcmerTypelist to use the int data type.

B.
Convert @CustomerTypeList to a table variable.

C.
Convert @CustomerTypeList to an XML variable.

D.
Update @CustomerTypeList to use the XML data type.


Leave a Reply