September 3, 2012 at 8:16 pm
Comments posted to this topic are about the item Table Variable
September 3, 2012 at 8:17 pm
September 4, 2012 at 12:09 am
Good Question to refresh our basics
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
September 4, 2012 at 12:30 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2012 at 1:46 am
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]
September 4, 2012 at 1:59 am
Nice question. Thanks!
September 4, 2012 at 2:12 am
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
September 4, 2012 at 2:38 am
This was removed by the editor as SPAM
September 4, 2012 at 2:40 am
Easy question - if only I'd noticed that it was a table variable!
September 4, 2012 at 2:46 am
Nice question...I got it right
For them those who got it wrong....
" Table variable is out of scope from Transactions "...
September 4, 2012 at 3:17 am
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.
September 4, 2012 at 3:28 am
nice question.
i have blindly answered and got it wrong.
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
September 4, 2012 at 4:35 am
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...
September 4, 2012 at 6:21 am
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
September 4, 2012 at 6:38 am
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.
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy