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?
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.