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
   OUTPUT deleted.*;

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.

Thanks For sharing.....

@kr.roopesh actually, DELETE can have two OUTPUT clauses - one with INTO and one without. Then in one statement you delete from transaction table, insert into history table, and output to application that will process transactional rows.