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.