Transact-SQL DML Commands

Table Manipulation

INSERT INTO table_name
     [ ( column_name [,... column_name ] ) ]
VALUES
     ( value [,... value ] )

Insert new rows into a table

  2005-2008r2

Insert a whole row into the Person table

INSERT INTO Person VALUES ('Brown', 'Joe', 35)

Insert a whole row into the Person table (with named columns)

INSERT INTO Person
    (LastName, FirstName, Age)
VALUES
    ('Brown', 'Joe', 35)

UPDATE table_name
SET
     column_name = value [,... column_name = value ]
[ WHERE where_clause ]

Update one or several columns in rows

  2005-2008r2

sets the Age to 45 of all Person rows with a LastName of 'Brown'

UPDATE Person
SET Age = 45
WHERE LastName = 'Brown'

DELETE FROM table_name
[ WHERE where_clause ]

Delete rows from a table

  2005-2008r2

deletes all rows from Person with a LastName of 'Brown'

DELETE FROM Person
WHERE LastName = 'Brown'

TRUNCATE TABLE table_name

Deletes all data from a table (truncates)

  2005-2008r2

delete all rows from the Person table

TRUNCATE TABLE Person