The DELETE statement in SQL Server

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 13 Dec 2010 07:00:00 UT Indexed on 2010/12/21 7:58 UTC
Read the original article Hit count: 213

Filed under:
Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.
SQL Monitor NEW! SQL Monitor 2.0
Monitor SQL Server Central's servers with
Red Gate's new SQL Monitor.
No installation required. Find out more.

© SQL Server Central or respective owner