Which of the following is TRUE with regards to table-valued parameters

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

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:



Leave a Reply 2

Your email address will not be published. Required fields are marked *