No, the
order of columns in UPDATE statement does not matter for results updated.
Both the
below options produce the same results.
Option 1:
UPDATE
TableName
SET Col1 ='Value', Col2 ='Value2'
SET Col1 ='Value', Col2 ='Value2'
Option 2:
UPDATE
TableName
SET Col2 ='Value2', Col1 ='Value'
SET Col2 ='Value2', Col1 ='Value'
No comments :
Post a Comment