DELETE TableOrView
[FROM TableSources]
[WHERE WhereRowSearchCondition]
INSERT [INTO] TableOrView [(ColumnList)]
{ VALUES (ListOfValues) | SELECTSubquery }
UPDATE TableOrView
SET Column&ExpressionList [FROM TableSources]
[WHERE WhereRowSearchCondition]
SELECT [ALL | DISTINCT] [TOP n [PERCENT]] SelectList
[INTO NewTable]
[FROM TableSources]
[WHERE WhereRowSearchCondition]
[
  GROUP BY [ALL] GroupList [WITH [CUBE | ROLLUP]]
  [HAVING HavingRowSearchCondition]
]
[ORDER BY OrderList [ASC | DESC]]
[
  COMPUTE ComputeList
  [BY ComputeByList]
]
SELECTCommand1
UNION [ALL]
SELECTCommand2

Page Modified: (Hand noted: 2007-10-12 18:45:59Z) (Auto noted: 2007-11-17 06:44:03Z)