Updating a field based on the value of another field

• Leighton21

  Mr or Mrs. 500

  Points: 557

  More actions

  March 21, 2004 at 5:02 am

  #178721

  Hi all,

  I am a newbie to SQL server and at the moment I am trying to write a trigger that fires if the value of a field is changed. The trigger works i.e. I can update the filed to a value I specify

  eg UPDATE Employees SET lastname = 'papa' WHERE lastname = 'king'

  What I would like to do is update the field to a value stored in another field in the database. Is this possible and how would I go about doing it.

  Something like this

  UPDATE Employees SET lastname = ?????? WHERE lastname = 'king'

  Where the ????? would be a reference to the field that contains the value

  Regards

  Lee

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  March 21, 2004 at 5:17 am

  #499664

  If you want to update the lastname value to equal the value of a column that has the lastname value of king

   

  update Employees SET lastname = newlastname where lastname = 'king' --(newlastname being the column that you want to use to populate the lastname column)

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 21, 2004 at 6:28 am

  #499667

  Unless that field isn't in the same table then you do something like this.

   

  Update E

  SET Lastname = T2.newlast

  FROM

  Employees E

  INNER JOIN

  table2 T2

  ON

  E.coltolink = T2.coltolink