You are developing an application that stores data in SQL Server 2005 database. You need to write a query that retrieves all orders in the orders table that were placed on January 1, 2011. You write the following query:

SELECT * FROM Orders

WHERE OrderDate = 01/01/2011

The statement executes without any error but does not return any data. You are certain that the database contains order from this date. How should you correct the SQL statement?

Question

You are developing an application that stores data in SQL Server 2005 database. You need to write a query that retrieves all orders in the orders table that were placed on January 1, 2011. You write the following query:

SELECT * FROM Orders
WHERE OrderDate = 01/01/2011

The statement executes without any error but does not return any data. You are certain that the database contains order from this date. How should you correct the SQL statement?

Accepted Answer

C. SELECT * FROM Orders

Answer

A. SELECT * FROM Orders

Answer

B. SELECT * FROM Orders

Answer

D. SELECT * FROM Orders

You are developing an application that stores data in SQL Server 2005 database. You need to write a query that retrieves all orders in the orders table that were placed on January 1, 2011. You write…

Question

Options

How the community answered

Community Discussion