Your application database includes the table Annotations. This table includes the following columns:

* An automatically generated integer identity column named AnnotationID
* A column of type varchar named AnnotationText
* A column of type datetime named Date

You must write a statement to insert a row into this table with parameter values @text and @date.

Which statement should you use?

 Posted by Rajkatie on 9/5/2012 | Category: ADO.NET Interview questions | Views: 1204 | Points: 40
Select from following answers:
  1. INSERT INTO Annotations (AnnotationText, Date) VALUES (@text, @date)
  2. INSERT INTO Annotations (@text, @date) VALUES (AnnotationID, AnnotationText, Date)
  3. INSERT INTO Annotations (AnnotationID, AnnotationText, Date) VALUES (@text, @date)
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response