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?

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



Leave a Reply 1

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


Minion

Minion

Because Stored Procedure cannot be called from a view. D it is.