Hi,
Is there any way I can copy the deleted records into a New table,
FOR EXAMPLE
delete from Table where column '1'
IS POSSIBLE THAT I CAN DO SOMETHING LIKE THIS
delete from Table into Temptable where column '1'
I tired this in SQL but it did not work. It shows me this error: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'into'.