You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
You plan to create a stored procedure. You need to configure a parameter that will enable the
stored procedure to receive multiple rows of data without creating a temporary table or many
parameters.
Which of the following will enable this functionality?
A.
Bulk Insert.
B.
Extensible Markup Language (XML)
C.
A FileTable.
D.
A Table-Valued Parameter.
Explanation: