Output clause can be used with DML commands (insert, update, delete).
It works using magic tables of deleted and inserted.
If you re-write the above query as
delete from Employee_Details
It will return the records affected.
if you set sp_configure for option "disallow results from triggers", output clause without into will raise the error.
commented on Oct 4 2012 5:05AM