Home » Microsoft » 70-765 » 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
Correct Answer: D
Explanation/Reference:
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