Value of Field in Updated Row within Trigger

• jwellington

  Ten Centuries

  Points: 1062

  More actions

  October 29, 2008 at 7:45 pm

  #193051

  Hi,

  I have a trigger on Update of Field1 and I would like to find out the value of Field2 for the Updated row.

  Does anyone know how to do this, or know the SQL command for this. I am new to SQL programming.

  Thanks

  P.S I have looked on the net and found that some use 'Inserted' to refer to an Inserted Record. I have tried referring to the row as 'Updated' but that does not work.

• jwellington

  Ten Centuries

  Points: 1062

  More actions

  October 29, 2008 at 8:06 pm

  #891574

  Hi,

  Please ignore this post. I have used 'Inserted' and it seems to work.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 30, 2008 at 7:03 am

  #891729

  If you are new to SQL and triggers I would recommend you read this article so you avoid some common mistakes made in triggers: http://www.sqlservercentral.com/articles/Triggers/64214/

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• jwellington

  Ten Centuries

  Points: 1062

  More actions

  November 3, 2008 at 5:21 pm

  #893342

  Thanks Jack. The link was helpful.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 4, 2008 at 5:41 pm

  #893978

  Great, I hope it helped you understand triggers better.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question