You need to create an object that meets the following r…

You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that
meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?

You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that
meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?

A.
Scalar-valued function

B.
Inline function

C.
User-defined data type

D.
Stored procedure

Explanation:
Stored procedures accept input parameters and return multiple values in the form of output parameters to the
calling program. They cannot be used in views.
https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-proceduresdatabase-engine



Leave a Reply 1

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