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
Because Stored Procedure cannot be called from a view. D it is.