You need to encapsulate a T-SQL script into a reusable user-defined object.
The object must meet the following requirements:
Permit insertions into a table variable.
Support structured exception handling.
Prevent changes to the definition of referenced objects.
Support the use of the APPLY operator on the output of the object.
Which type of object should you use?
A.
An inline table-valued function
B.
A stored procedure
C.
A scalar user-defined function
D.
A multi-statement table-valued function
Answer is D.