Friday, February 28, 2014

How the OUTPUT statement works with a DELETE statement

DECLARE @del_table TABLE (emp_no INT, emp_lname CHAR(20));

DELETE employee
OUTPUT DELETED.emp_no, DELETED.emp_lname INTO @del_table
WHERE emp_no > 15000;


SELECT * FROM @del_table

No comments:

Post a Comment

Generate All Database Backup From Sql Server Using Query

DECLARE   @name   VARCHAR ( 50 )   -- database name DECLARE   @path   VARCHAR ( 256 )   -- path for backup files DECLARE   @fileName  ...