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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine