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
should be D?
D
“Support structured exception handling.”
That may be the end of this write-up. Right here you will find some sites that we consider you will value, just click the hyperlinks.
D is the correct answer
C is the correct ANS