70-516 · Question #270
You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database. CREATE TABLE Orders( ID numeric(18…
The correct answer is B. Dim time As TimeSpan = DirectCast(rdr(1), TimeSpan). Pay attention to the fact that it goes about Microsoft SQL Server 2008 in the question. Types date and time are not supported in Microsoft SQL Server Express. time (Transact SQL) Using date and time data Date and time functions SQL Server Data Type Mappings (ADO.NET)
Question
You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database. CREATE TABLE Orders( ID numeric(18, 0) NOT NULL, OrderNaroe varchac (50) NULL, OrderTime time (7) NULL, OrderDate dace NULL) You write the following code to retrieve data from the OrderTime column. (Line numbers are included for reference only.) 01 Dim conn As SqlConnection = New SqlConnection(""*") 02 conn.Open() 03 Dim cmd As SqlCommand = New SqlCommand( "SELECT ID, OrderTime FROM Orders", conn) 04 Dim rdr As SqlDacaReader = crod.ExecuteReader() 06 While rdr.Read() 08 End While You need to retrieve the OrderTime data from the database. Which code segment should you insert at line 07?
Options
- ADim time As DateTime = DirectCast (rdr (1), DateTime)
- BDim time As TimeSpan = DirectCast(rdr(1), TimeSpan)
- CDim time As Timer = DirectCast(rdr(1), Timer)
- DDim time As String = DirectCast(rdr(1), String)
How the community answered
(52 responses)- A4% (2)
- B73% (38)
- C15% (8)
- D8% (4)
Explanation
Pay attention to the fact that it goes about Microsoft SQL Server 2008 in the question. Types date and time are not supported in Microsoft SQL Server Express. time (Transact SQL) Using date and time data Date and time functions SQL Server Data Type Mappings (ADO.NET)
Topics
Community Discussion
No community discussion yet for this question.