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

  Discussion forum


Leave an answer