need help with Columns_Updated() in a trigger

• shuja khan

  Newbie

  Points: 2

  More actions

  November 17, 2006 at 5:25 am

  #173501

  I have a table with 18 columns. The trigger on this table would do something if the 14th column has been updated.

  I want to check if the 14th column has been updated. The other columns might or might not be updated. My solution has to pivot on the updation of the 14th column.

  Please help me get the correct sysntax using Columns_Updated() for checking the 14th column.

  Thanks

• ijaz

  SSCommitted

  Points: 1912

  More actions

  November 17, 2006 at 6:19 am

  #672561

  Hi,

  Why not you can use the Update clause rather than updated_columns

  IF UPDATE(Column14)

    -- do something

  else

     -- do nothing

   

  cheers

   

  cheers

• shuja khan

  Newbie

  Points: 2

  More actions

  November 17, 2006 at 7:14 am

  #672586

  Sorry for presenting the entire picture....

  The 14th Column is of type ntext and hence cannot be used in the After Update trigger directly. I am limited to use Instead Of Update .