Microsoft
70-457 · Question #4
You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event…
The correct answer is E. Use a user-defined table type. See the full explanation below for the reasoning.
Question
You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?
Options
- AUse the CAST function.
- BUse the DATE data type.
- CUse the FORMAT function.
- DUse an appropriate collation.
- EUse a user-defined table type.
- FUse the VARBINARY data type.
- GUse the DATETIME data type.
- HUse the DATETIME2 data type.
- JUse the TODATETIMEOFFSET function.
How the community answered
(27 responses)- B4% (1)
- C11% (3)
- E78% (21)
- G7% (2)
Community Discussion
No community discussion yet for this question.