Which options should you identify?

DRAG DROP
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.)

DRAG DROP
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.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *