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:
EXECUTEup_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.