In-line variable assignment 1
-
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/ -
Hugo, you always are the NUMBER ONE!
WOW, another qotd with a special offer with "SUMMER POINTS"!
-
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 -
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 -
Thanx 4 the easy 2 pts.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
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. -
Nice question, thanks for sharing
-
This was removed by the editor as SPAM
-
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
-
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 -
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.
-
I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:
-
Good question, Hugo. Thanks!
---------------
Mel.
-
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. -
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.
Viewing 15 posts - 1 through 15 (of 37 total)
You must be logged in to reply to this topic. Login to reply