Joel
4Penny.net
Points: 10550

11/8/2016 10:28:11 AM

DELETE into an OUTPUT table

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Did you know that it is possible to OUTPUT a table from a DELETE statement? This OUTPUT table would contain all the rows that you deleted, and you can then use that table in other processes.

Sample code below.

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3