Swap columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Nakul Vachhrajani » Swap columns

22 posts, Page 3 of 3

«««1 2 3

Swap columns

Rate Topic

Display Mode

Topic Options

Author

Message

sgmunson

Posted Friday, January 21, 2011 9:41 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883

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)
Smile

Steve
(aka sgmunson)
Smile

Weight Loss Tips

Post #1051644

terrykzncs

Posted Monday, May 02, 2011 11:29 PM

SSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 04, 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. Cool

Post #1102106

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions