Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 25, 1997

INSERT INTO Syntax

Question:
What is the standard SQL-92 syntax for INSERT INTO?

Answer:
Be sure to check your product documentation for any variations! This is standard syntax, but not all products will implement each aspect of the standard, and may include additional extensions.

This is the BNF grammar for the elements related to the INSERT INTO command. (Some of the more obvious definitions were not included for the sake of space—for instance, I'm assuming that the reader will know what

means.)
 ::=
    INSERT INTO 
::= [ ] &124; DEFAULT VALUES ::= Examples:
INSERT INTO Inventory
        VALUES ('A102', 'Widget', 431);

INSERT INTO Customers (cust_no, name, balance)
        VALUES (33892, 'James Thomason', 312.33);
DevX Pro
 
Submit a Tip Browse "Database Development" Tips Browse All Tips
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date