Hi All, i am using sql server 2005 i am mainiting the History of my table so before update record how to insert the record in history table two table have same columns using trigger please help meeeeeeeeeeeeeeeeeee.......... yours pole.
You can write after insert update trigger for the same which is very easy in case on insert but for update you need to write if conditions on all the columns which can be updated...... where you can track the new value and the old value for a column in not same......