August 4, 2014 at 10:20 pm
Comments posted to this topic are about the item In-line variable assignment 1
August 5, 2014 at 1:03 am
Hugo, you always are the NUMBER ONE!
😀
WOW, another qotd with a special offer with "SUMMER POINTS"!
😀
August 5, 2014 at 1:05 am
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
August 5, 2014 at 1:13 am
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
August 5, 2014 at 1:14 am
Thanx 4 the easy 2 pts.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 5, 2014 at 3:07 am
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.
August 5, 2014 at 3:49 am
Nice question, thanks for sharing
August 5, 2014 at 4:19 am
This was removed by the editor as SPAM
August 5, 2014 at 4:20 am
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
August 5, 2014 at 4:30 am
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
August 5, 2014 at 5:11 am
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.
August 5, 2014 at 5:16 am
I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:
August 5, 2014 at 5:35 am
Good question, Hugo. Thanks!
---------------
Mel. 😎
August 5, 2014 at 5:36 am
TomThomson (8/5/2014)
+1
---------------
Mel. 😎
August 5, 2014 at 5:51 am
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