Monday, December 11, 2006

INSERT INTO

The INSERT INTO statement is a data manipulation language (DML) command. It inserts a new row into the table.

Syntax: INSERT INTO table_name [(column[, column])] VALUES (value[, value]);

See MS Doc: INSERT Transact-SQL

Example Code:

CREATE TABLE Person (LastName varchar(80), FirstName varchar(80));
INSERT INTO Person VALUES ('Hughes', 'Stan');
SELECT * FROM Person;

No comments: