In-line variable assignment 1

Question

Post reply

In-line variable assignment 1

Hugo Kornelis

SSC Guru

Points: 64790
More actions
August 4, 2014 at 10:20 pm

#297612

Comments posted to this topic are about the item In-line variable assignment 1
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
August 5, 2014 at 4:19 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 1

Hugo, you always are the NUMBER ONE!

😀

WOW, another qotd with a special offer with "SUMMER POINTS"!

😀

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Nice question Hugo.

Your explanation left out "compound assignment operator" however 🙂

http://technet.microsoft.com/en-us/library/ms189484(v=sql.100).aspx

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

Carlo Romagnano (8/5/2014)
Hugo, you always are the NUMBER ONE!
😀
WOW, another qotd with a special offer with "SUMMER POINTS"!
😀

🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Thanx 4 the easy 2 pts.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

Thank you, Hugo, it was very simple and easy, for me. 🙂

(have one sql script written where the variables are assigned this way, so was sure of my choices. I executed the script in 2008R2, and I re-read the question and see there is no R2, but still went with the gut feeling that this must work, and yes, it does)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Umer Akram SSC-Insane Points: 22209 More actions · Answer 6

Umer Akram

SSC-Insane

Points: 22209

August 5, 2014 at 3:49 am

#1735054

Nice question, thanks for sharing

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Nice simple question. The only difficulty was remembering what release the feature was introduced in, 2008 or 2008R2, and then I remembered which release Neos was upgrading to after 2000, and that was 2008.

edit: I'm amazed how many people fell for one of the two "only simple values, no expressions" options; and that only 44% got it right.

Tom

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

TomThomson (8/5/2014)
edit: I'm amazed how many people fell for one of the two "only simple values, no expressions" options; and that only 44% got it right.

The Interwebz, they never cease to amaze us 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 9

After a while now you'd think I would have learned! I guess not. I am sure like others that missed this question was the fact that I read through the question too fast and picked: "The Select returns 6", without reading the question which clearly states: "Pick two correct answers". Thanks Hugo, I have to learn to be patient and read the question AFTER I get my coffee.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 10

I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:

SqlMel SSCrazy Points: 2901 More actions · Answer 11

Good question, Hugo. Thanks!

---------------
Mel. 😎

SqlMel SSCrazy Points: 2901 More actions · Answer 12

TomThomson (8/5/2014)

Nice simple question. The only difficulty was remembering what release the feature was introduced in, 2008 or 2008R2, and then I remembered which release Neos was upgrading to after 2000, and that was 2008.

+1

---------------
Mel. 😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 13

Thanks for the question. Honestly, I used inline assignment so much that I didn't even give it a second look. The += however, I had to look three times at that one and try to remember the article I read a while back. I don't use it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions