Microsoft
70-516 · Question #120
You are calling a stored procedure in SQL Server 2008 that returns a UDT as an output parameter. This UDT, called MyCompanyType, was created by your company. The UDT has a method called GetDetails…
The correct answer is A. Set the SqlDbType of the parameter to SqlDbType.Udt. B. Set the UdtTypeName of the parameter to MyCompanyType. D. In the client application, set a reference to the assembly in which the UDT is. See the full explanation below for the reasoning.
Question
You are calling a stored procedure in SQL Server 2008 that returns a UDT as an output parameter. This UDT, called MyCompanyType, was created by your company. The UDT has a method called GetDetails that you want to execute in your client application. What must you do to execute the method? (Each correct answer presents part of a complete solution. Choose three.)
Options
- ASet the SqlDbType of the parameter to SqlDbType.Udt.
- BSet the UdtTypeName of the parameter to MyCompanyType.
- CCall the ExecuteXmlReader method on the SqlCommand to serialize the UDT as XML.
- DIn the client application, set a reference to the assembly in which the UDT is.
How the community answered
(38 responses)- A71% (27)
- C29% (11)
Community Discussion
No community discussion yet for this question.