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 the solution. Choose three.)

 Posted by Rajkatie on 8/13/2012 | Category: ADO.NET Interview questions | Views: 2020 | Points: 40
Select from following answers:
  1. Set the UdtTypeName of the parameter to MyCompanyType.
  2. Set the SqlDbType of the parameter to SqlDbType.Udt.
  3. In the client application, set a reference to the assembly in which the UDT is defined.
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response