You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requireme
Posted: Mon Oct 17, 2022 4:50 pm
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
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