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