You need to develop a stored procedure strategy that will manipulate temporary result sets
to meet the following requirements: • Stored procedures must receive result sets as
parameters • The strategy must be developed by using the minimum amount of effort The
result sets will contain less than 1,000 rows. What should you use?

A.
a common table expression (CTE)

B.
a view

C.
a user-defined table type

D.
a scalar function

Explanation: