You are planning two stored procedures named SProc1 and SProc2.
You identify the following requirements:
SProc1 must return a table.SProc2 must return a scalar value.
You need to identify which option must be implemented for each stored procedure to return the desired data.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be
used once, more than once, or not at all.)
Select and Place:

Answer:

Explanation:
Note:
* a table (a set of rows) can be returned through a SELECT statement
*a scalar can be returned through an output parameter.
* incorrect: TVP is used for input not output.