Table Variable

Question

Post reply

Table Variable

Sreepathi1987

Default port

Points: 1425
More actions
September 3, 2012 at 8:16 pm

#393082

Comments posted to this topic are about the item Table Variable
September 4, 2012 at 2:38 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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]

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Great question, thanks.

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

DugyC Hall of Fame Points: 3804 More actions · Answer 4

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]

Divine Flame SSCoach Points: 15943 More actions · Answer 5

Divine Flame

SSCoach

Points: 15943

September 4, 2012 at 1:59 am

#1533141

Nice question. Thanks!

Sujeet Singh

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 6

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

Toreador SSChampion Points: 11368 More actions · Answer 7

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

cmnayal SSC Rookie Points: 31 More actions · Answer 8

Nice question...I got it right 😉

For them those who got it wrong....

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

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.

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 10

nice question.

i have blindly answered and got it wrong.

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

Ola L Martins-329921 Mr or Mrs. 500 Points: 542 More actions · Answer 11

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...

TomThomson SSC Guru Points: 104773 More actions · Answer 12

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

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

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!