You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing tablevalued parameters.
Which of the following is TRUE with regards to table-valued parameters
A.
You are allowed to use a table-valued parameter as the target of a SELECT INTO or INSERT
EXEC statement.
B.
A table-valued parameter can be in the FROM clause of SELECT INTO or in the INSERT
EXEC string or stored procedure.
C.
Table-valued parameters must be passed as input READONLY parameters to Transact-SQL
routines.
D.
You are allowed to execute DML operations such as UPDATE, DELETE, or INSERT on a tablevalued parameter in the body of a routine.
Explanation:
http://technet.microsoft.com/en-us/library/bb510489.aspx
?