Which object should you use?

You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the
following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?

You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the
following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?

A.
Inline user-defined function

B.
Stored procedure

C.
Table-valued user-defined function

D.
Scalar user-defined function



Leave a Reply 3

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