Table Variable

  • Comments posted to this topic are about the item Table Variable

  • Nice question - make sure one knows the basics

    Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Good Question to refresh our basics 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Great question, thanks.

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

  • At first glance my instinct was to go with zero, but then I noticed it was a table variable.

    Phew 😀

    Good question, thanks.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Nice question. Thanks!


    Sujeet Singh

  • DugyC (9/4/2012)


    At first glance my instinct was to go with zero, but then I noticed it was a table variable.

    Phew 😀

    Good question, thanks.

    +1

    Knew the issue with Table Variable, so nearly went with two! Then I noticed the Try Catch... And thought about the error.

    Good thing I waited for my cup of coffee first!:-D

    Thanks for the great question

  • This was removed by the editor as SPAM

  • Easy question - if only I'd noticed that it was a table variable!

  • Nice question...I got it right 😉

    For them those who got it wrong....

    " Table variable is out of scope from Transactions "...

  • Awesome, good question, thank you. 🙂

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

  • nice question.

    i have blindly answered and got it wrong.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Didn't know about the table-variable... 🙁

    I saw that. And I knew there was a catch - but failed to draw the correct conclusion...

    Nice Q and Good To Know...

  • Terrific question.

    Nicely illustrates what might be thought of as a nasty problem with table variables, but can sometimes be a big plus point.

    Tom

  • Thank you for the terrific question. I must say it almost bit me this morning until I took a second look. Zombie mode almost had me this morning, but then I noticed it was a table variable.



    Everything is awesome!

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

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