Biskot2 Posted August 1, 2019 Report Share Posted August 1, 2019 8 hours ago, Sarvapindi said: Sql experts randi va..oka qn i have a table .. Table A... With 1000 records with columns below id. Name this table will be updated everyday...so some records will be deleted or some new records will be inserted. I want to find what are the records thats r inserted and records that r deleted everyday...and load those into another table... how to do trigger on insert and trigger on delete than fetch that data, insert into another table last ke Jai balaya anu gattiga Quote Link to comment Share on other sites More sharing options...
Spartan Posted August 1, 2019 Report Share Posted August 1, 2019 15 hours ago, Suhaas said: This should work Change “UPDATE” to “DELETE” in the above statement as per OP’s requirement yeah Delete should be used. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.