Heh... While what you say is true, I'll take the bet that it'll work with the next SQL Server update... and the next several dozen after that. 😉
The major concern that I have with this trick is that if @a and @B are each more than 50% (or some other combination) of the maximum for the given datatype, then @a+@B will cause a failure. It would be much safer (and perhaps quicker because there's no math involved) to use the 3 variable method for doing such a swap.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)