70-516 · Question #9
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You need to ensure that the…
The correct answer is D. Set the SqlDbType of SqlParameter to Structured. SqlParameter.DbType Gets or sets the SqlDbType of the parameter. SqlParameter.TypeName Gets or sets the type name for a table-valued parameter. SqlDbType.Structured A special data type for specifying structured data contained in table-valued Udt A SQL Server 2005 user-defined…
Question
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You need to ensure that the application calls a stored procedure that accepts a table-valued parameter. You create a SqlParameter object. What should you do next?
Options
- ASet the SqlDbType of SqlParameter to Udt.
- BSet the SqlDbType of SqlParameter to Variant.
- CSet the ParameterDirection of SqlParameter to Output.
- DSet the SqlDbType of SqlParameter to Structured.
How the community answered
(31 responses)- A3% (1)
- B13% (4)
- C3% (1)
- D81% (25)
Explanation
SqlParameter.DbType Gets or sets the SqlDbType of the parameter. SqlParameter.TypeName Gets or sets the type name for a table-valued parameter. SqlDbType.Structured A special data type for specifying structured data contained in table-valued Udt A SQL Server 2005 user-defined type (UDT). Types of Spatial Data
Topics
Community Discussion
No community discussion yet for this question.