UPDATE TRIGGER ON TABLE
Trigger are three types : INSERT, UPDATE, DELETE and trigger have two magic table INSERTED and DELETED... when we execute DML (INSERT, UPDATE, DELETE) operation then trigger is automatically execute. example : I have three table INWARD , OUTWARD and ALLTYPESTOCK OK. so when i insert data in "inward" table then data insert not only inward but also in "alltypestock" table. and same situation with outward... SO task is data of both table is store in ALLTYPESTOCK table, when i want to chage(update) any data of alltypestock then automatically data update which came form the table . UPDATE TRIGGER: ------------------- INWARDSTOCK ...