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?
You Have A Sql 1 (38.39 KiB) Viewed 117 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!