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: 209
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.
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