update statement multiple fields

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  May 11, 2010 at 9:11 am

  #218792

  Hi,

  I think the sql server process the following query right but I just wanted to make sure with you. If I have the update statement like this

  update table1

  set field1 = field1 + field2 + field3 - field4,

  field2 = 0,

  field3 = 0,

  field4 = 0;

  will it process the above statement in the right order? I mean will it update field1 with the

  (field1 + field2 + field3 - field4) before it resets field2, field3, field4?

  Thanks,

  sridhar.

• Eric M Russell

  SSC Guru

  Points: 125561

  More actions

  May 11, 2010 at 9:17 am

  #1165622

  field1 will be set to whatever (field1 + field2 + field3 - field4) equals when the UPDATE statement initially starts.

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho