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
You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requireme
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requireme
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!