Microsoft
70-451 · Question #115
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…
The correct answer is C. a user-defined table type. See the full explanation below for the reasoning.
Question
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?
Options
- Aa common table expression (CTE)
- Ba view
- Ca user-defined table type
- Da scalar function
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C83% (20)
- D8% (2)
Community Discussion
No community discussion yet for this question.