Prev Question
Next Question

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?

Scalar-valued function

Inline function

User-defined data type

Stored procedure

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.

Prev Question
Next Question

Leave a Reply

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