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