SQL Server Performance

How To write before Trigger in sql server 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by polaiah, Sep 22, 2009.

  1. polaiah New Member

    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.
  2. rohit2900 Member

    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......

Share This Page