Trigger
-
Hi, Can I get previous and current values of row in trigger for update operation. Regards, Shah A.
-
Hi, Can I get previous and current values of row in trigger for update operation. Regards, Shah A.
Use updated.colname Live Life King Size Alomgir Miah
-
Use updated.colname Live Life King Size Alomgir Miah
Thanks for the reply Alomgir. Can you pls elaborate? I think updated.colname will give the value after the execution of query. How can I get the previous value, so that I can compare both. Regards, Shah Adarsh.
-
Thanks for the reply Alomgir. Can you pls elaborate? I think updated.colname will give the value after the execution of query. How can I get the previous value, so that I can compare both. Regards, Shah Adarsh.
I got the answer:). deleted table contains the old record and the inserted table contains the newer one for update operation trigger. Regards, Shah Adarsh.