70-516 · Question #198
You use Microsoft .NET Framework 4.0 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 A. TimeSpan time = (TimeSpan)rdr[1]. 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.0 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, OrderName varchar(50) NULL, OrderTime time(7) NULL, OrderDate date NULL) You write the following code to retrieve data from the OrderTime column. (Line numbers are included for reference only.) 01 SqlConnection conn = new SqlConnection("…"); 02 conn.Open(); 03 SqlCommand cmd = new SqlCommand("SELECT ID, OrderTime FROM Orders", conn); 04 SqlDataReader rdr = cmd.ExecuteReader(); 05 .... 06 while(rdr.Read()) 07 { 08 .... 09 } You need to retrieve the OrderTime data from the database. Which code segment should you insert at line 08?
Options
- ATimeSpan time = (TimeSpan)rdr[1];
- BTimer time = (Timer)rdr[1];
- Cstring time = (string)rdr[1];
- DDateTime time = (DateTime)rdr[1];
How the community answered
(27 responses)- A74% (20)
- B7% (2)
- C15% (4)
- D4% (1)
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.