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: