Table Variable

Question

Post reply

Table Variable

Sergiy

SSC Guru

Points: 110208
More actions
April 29, 2013 at 9:26 pm

#272001

Comments posted to this topic are about the item Table Variable
_____________
Code for TallyGenerator

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

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

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 1

Nice question. thanks

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Nice question. Thanks!

~ 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

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Thanks for the good question 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

Welcome back Lokesh, after a long time I see you man :-P;-)

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 5

Good question with important information.

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

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 6

kapil_kk (4/29/2013)
Welcome back Lokesh, after a long time I see you man :-P;-)

me too !!! :-):-):-)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 7

Danny Ocean (4/29/2013)
kapil_kk (4/29/2013)
Welcome back Lokesh, after a long time I see you man :-P;-)
me too !!! :-):-):-)

Thanks Kapil and Vinay.

Was keeping busy with my Master's exams. Finally they are over 😀

~ 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

Gobikannan SSCrazy Points: 2735 More actions · Answer 8

Gobikannan

SSCrazy

Points: 2735

April 29, 2013 at 11:27 pm

#1611105

Good question.

-----------------
Gobikannan

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 9

Lokesh Vij (4/29/2013)

Was keeping busy with my Master's exams. Finally they are over 😀

So now its party time 😀

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 10

Danny Ocean (4/29/2013)

Lokesh Vij (4/29/2013)
Was keeping busy with my Master's exams. Finally they are over 😀
So now its party time 😀

Oh Yes..Sure!!

Have to submit dissertation/thesis by the end of December. Any research idea's please?? 😉

~ 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

Sergiy SSC Guru Points: 110208 More actions · Answer 11

Thanks everyone for positive feedback.

As you can guess the question came from practical experience when developers were puzzled with "odd" behaviour of SQL Server.

Had to build this sample script to make the matter clear.

Then it appeared to me other might benefit from it too.

_____________
Code for TallyGenerator

kapil_kk SSC-Insane Points: 21316 More actions · Answer 12

Sergiy (4/29/2013)
Thanks everyone for positive feedback.
As you can guess the question came from practical experience when developers were puzzled with "odd" behaviour of SQL Server.
Had to build this sample script to make the matter clear.
Then it appeared to me other might benefit from it too.

+1 :-):-D

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

zymos SSCommitted Points: 1960 More actions · Answer 13

Thanks for the tricky question on table variables. I enjoyed. 🙂

Lokesh Vij SSChampion Points: 10836 More actions · Answer 14

Sergiy (4/29/2013)
Then it appeared to me other might benefit from it too.

Much appreciated Sergiy. Keep it up! 🙂

~ 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