Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Swap columns Expand / Collapse
Author
Message
Posted Friday, January 21, 2011 9:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 8, 2014 4:07 PM
Points: 1,669, Visits: 2,215
The very reason I got this one wrong was precisely because of posts here that described the "Qurky Update", and thus I was left with the idea that the SET statement's actions operated left to right, in order of appearance in the statement.

I have used that quirky update thing a number of times, and it was so darn handy, that I came to believe something about it that turns out to not be true for a swap field values scenario. Quite interesting, and clearly, a good "teaching moment"...

Many thanks !!!

Steve
(aka sgmunson)


Steve
(aka sgmunson)

Internet ATM Machine
Post #1051644
Posted Monday, May 2, 2011 11:29 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 4, 2012 4:02 AM
Points: 660, Visits: 134
Thanks for the question.

What it does highlight for us 'Newbies' in SQL, is the order of statements being processed, in this case the whole of the SELECT before the FROM is executed as one.


Post #1102106
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse