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

View Answer

Answer: C