locked
How to use before update trigger in sql server RRS feed

  • Question

  • User-1569093213 posted

    Hello sir,

    I want to use before update trigger in sql.i want to fetch the row which will be updated into database and then perfom  actual update in database.how to get the row which is to be updated using trigger in sql.

    Thursday, January 21, 2016 5:23 AM

Answers

All replies

  • User1724605321 posted

    Hi BHUSHAN,

    Please refer to this thread: http://stackoverflow.com/questions/642822 :

    T-SQL supports only AFTER and INSTEAD OF triggers, it does not feature a BEFORE trigger, as found in some other RDBMSs.To do something before an update, check out INSTEAD OF UPDATE Triggers.

    Hope it helps.

    Best Regards,

    Nan Yu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 21, 2016 7:05 AM
  • User-698989805 posted

    Please go through these links:

    http://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx

    http://www.c-sharpcorner.com/UploadFile/4624e9/triggers-in-C-Sharp/

    Thursday, January 21, 2016 9:14 AM