how to create Delete trigger procedure

Question

Hi friends Pls Help me.. How to create trigger Procedure. I want to delete record one table the same value should be dynamically save in another table. How to create the trigger procedure. Give me sample trigger procedure Thanks

shiva krishna · Answer

hai

kavitha m · Answer

Hi Satish Kathi  Given trigger procedure working fine. You given me exact coding. Thanks a lot keep on answer my question. once again Thanks

Satish Kathi · Answer

Here is the sample code when you delete from table1 trigger will insert the values in table2. Hope this helps create trigger tD_tD_tabl1 on table1 for DELETE as begin declare @da nvarchar ( 10 ) @db nvarchar ( 10 ) declare mycursor cursor for select a  b from deleted open mycursor fetch mycursor into @da  @db while @@fetch_status - 1 BEGIN if @@fetch_status - 2 BEGIN insert into table2 ( c  d ) values ( @da  @db ) END fetch mycursor into @da  @db END close mycursor end