You are employed as a developer at ABC.com. ABC.com makes use of SQL Server 2005
databases in their environment.
You want to make sure that all ABC.com’s orders processed on the 8th May 2012 are returned by
a query to the ABCOrders database table.
You start by writing the line of code shown below:
SELECT * FROM Orders
Which of the following is the line of code that would suitably complete the query?
A.
WHERE OrderDate = ’08/05/2012′
B.
WHERE OrderDate = ‘8th May 2012’
C.
IF OrderDate = ’01/01/2011′
D.
IF OrderDate = ”8th May 2012′
A.