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

Show Hint

Leave a Reply 2

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

Novel Purification

Novel Purification

=> Stored Procedure cannot be called from a view
=> You can call function within a view
So The answer is ‘D’

Reply