Microsoft Exam Questions

You use Microsoft SQL Server 2012 to develop a database application. You need to create an object th

You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements:

T

akes 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