Temp Table

Question

Post reply

Temp Table

Nitin Bhargava

SSCarpal Tunnel

Points: 4617
More actions
June 24, 2013 at 10:08 pm

#278963

Comments posted to this topic are about the item Temp Table

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

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

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 1

PRAMANA.DBA

SSCertifiable

Points: 5507

June 24, 2013 at 10:40 pm

#1626973

Easy one ..... +1

Neeraj Prasad Sharma Ten Centuries Points: 1315 More actions · Answer 2

Lovely Tuesday morning 1+,

Back to BASIC...

Neeraj Prasad Sharma
Sql Server Tutorials

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Easy and good basic question. 🙂

Sometimes its good to play around basic. Its refresh us. 🙂

Thanks

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

demonfox SSCertifiable Points: 6289 More actions · Answer 4

easy one.

In case of global temporary table creation it will throw an error. i.e ##Table1

Local Temp just gets another session.

Thanks for the question.

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Lokesh Vij SSChampion Points: 10836 More actions · Answer 5

demonfox (6/25/2013)
easy one.
In case of global temporary table creation it will throw an error. i.e ##Table1
Local Temp just gets another session.
Thanks for the question.

Good point..

~ 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 6

Danny Ocean (6/24/2013)
Easy and good basic question. 🙂
Sometimes its good to play around basic. Its refresh us. 🙂
Thanks

+1 :-):-P

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

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 7

malleswarareddy_m

SSCertifiable

Points: 5847

June 25, 2013 at 1:50 am

#1627011

Easy one

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

begin.b4u Default port Points: 1451 More actions · Answer 8

begin.b4u

Default port

Points: 1451

June 25, 2013 at 2:02 am

#1627013

Its temporary table creation

Tock Default port Points: 1433 More actions · Answer 9

Perfect question for the morning after a night with little sleep 🙂

Cheers,

Steve

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

Tock (6/25/2013)
Perfect question for the morning after a night with little sleep 🙂
Cheers,
Steve

Unless you didn't read the question properly and skimmed the part about opening another query window... doh! :doze:

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