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)