How to insert the Data from one table to another table

Question

Suppose if delete one row from the database table then it should it insert into anoher table

Manish Dwivedi · Answer

Hi I have created two tables named Manish and Manish1 with the same schema and when i delete the record from the manish  it inserts in the manish1 with the help of trigger. SYntax for creating the trigger CREATE TRIGGER [TRG_Delete] ON [dbo].[Manish] FOR DELETE AS insert into Manish1 select * from deleted

chaitanya vonaja · Answer

Can u send me the sample code

Manish Dwivedi · Answer

Hi You can create trigger for insert the record in the another table when delete event occurs in the first table