How to know if the "IF UPDATE" statement was triggered by an Insert or an Update statement?

• Martial Bayron

  SSC Veteran

  Points: 251

  More actions

  February 13, 2004 at 12:42 am

  #107821

  HI All!

  I just wanted to know if there is a way to determine if the IF UPDATE() fuction is triggered by an INSERT statement or an UPDATE statement.

  thanks in advance.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  February 13, 2004 at 12:50 am

  #493946

  If triggered by an INSERT there'll be no rows in the DELETED table.

  
  Cheers,
  - Mark