Please only take this question if you are fluent in SQL Serv

Please only take this question if you are fluent in SQL Server.

Which of the following will NOT run?

A. SELECT OrderId, OrderDate FROM Orders

B. SELECT top 100 OrderId, OrderDate FROM Orders Where OrderDate < \'1996-07-24 00:00:00.000\'

C. SELECT top 100 OrderId, OrderDate FROM Orders Where OrderDate < \'1996-07-24\'

D. SELECT top 100 OrderId, OrderDate FROM Orders Where OrderDate < #1996-07-24#

E. All of the above queries will run wothout error

Solution

The query that do not run is:

D. SELECT top 100 OrderId, OrderDate FROM Orders Where OrderDate < #1996-07-24#