You develop a Microsoft SQL Server 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 proce

dure

C. Table-valued user-defined function

D. Scalar user-defined function

Explanation: