Which type of object should you use?

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?

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


derek cao

derek cao

should be D?

Vladimir

Vladimir

D
“Support structured exception handling.”

Google

Google

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.

M A

M A

D is the correct answer

krishtweety

krishtweety

C is the correct ANS