Adding New Data with INSERT

for RuBoard

Adding New Data with INSERT

You can enter new data into the database by using the INSERT SQL statement. The syntax of the command is fairly simple. However, before building the query to add new data, you must know the schema of the table. Figure 3.2 shows the schema of the Categories table in the Northwind database.

Figure 3.2. The Microsoft SQL Enterprise Manager can display the schema of your database to help you build queries.

graphics/03fig02.jpg

Notice that the table consists of four fields, including the CategoryID column. This field contains an integer that is automatically incremented for each new record added; we will not need to add a value with our query. Additionally, notice that the only required field in the table is CategoryName. The Description and Picture columns can both be left null. When executed, the statement in Listing 3.3 adds a new record into the category table:

 INSERT INTO Categories (   CategoryName,   Description ) VALUES (   'Spam',   'Spam and other canned-meat products' ) 

The first line uses the keywords INSERT INTO to specify that we are inserting the data into the Categories table. Then the first parenthesized section of code specifies the fields into which we're putting our data. The VALUES keyword and the next parenthesized section enter the actual values in the same column order as the first section.

for RuBoard


Sams Teach Yourself ADO. NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net