Your Microsoft SQL Server application database includes a table named Orders. This table includes a primary key column named OrderID and a column named Status. You must write a statement to set the Status column to the value of a parameter named @status for the row with the OrderID column matching the value of a parameter named @orderID.

Which statement should you use?

 Posted by Rajkatie on 9/9/2012 | Category: ADO.NET Interview questions | Views: 1037 | Points: 40
Select from following answers:
  1. UPDATE Orders SET [Status] = @status WHERE OrderID = @orderID
  2. UPDATE Orders SET [Status] = @status, OrderID = @orderID
  3. SELECT [Status] = @status FROM Orders WHERE OrderID = @orderID
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response