Microsoft SQL Server 2008 Bible

The BNF notations for DML statements follow:

INSERT INTO <table_or_view_name> [(<column_name>,...)] {{VALUES (<literal> | <expression> | NULL | DEFAULT,...)} | {<select_statement>} }

UPDATE <table_or_view_name> SET {<column_name> = <literal> | <expression> | <single_row_select_statement> | NULL | DEFAULT,...} [WHERE <predicate>]

DELETE FROM <table_or_view_name> WHERE <predicate>