Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Temp Table Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 10:08 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 11:22 PM
Points: 2,018, Visits: 65
Comments posted to this topic are about the item Temp Table
Post #1466968
Posted Monday, June 24, 2013 10:40 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 606, Visits: 812
Easy one ..... +1
Post #1466972
Posted Monday, June 24, 2013 11:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 27, 2013 5:37 AM
Points: 306, Visits: 524
Lovely Tuesday morning 1+,
Back to BASIC...


Neeraj Prasad Sharma
Sql Server Tutorials
Post #1466976
Posted Monday, June 24, 2013 11:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 06, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Easy and good basic question.
Sometimes its good to play around basic. Its refresh us.
Thanks




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1466982
Posted Tuesday, June 25, 2013 12:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:03 PM
Points: 1,128, Visits: 1,161
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
Post #1466986
Posted Tuesday, June 25, 2013 12:24 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
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
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1466992
Posted Tuesday, June 25, 2013 12:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:50 PM
Points: 1,867, Visits: 2,275
Danny Ocean (6/24/2013)
Easy and good basic question.
Sometimes its good to play around basic. Its refresh us.
Thanks

+1



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1466993
Posted Tuesday, June 25, 2013 1:50 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 3:59 AM
Points: 1,938, Visits: 1,149
Easy one

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1467017
Posted Tuesday, June 25, 2013 2:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 1:59 AM
Points: 288, Visits: 14
Its temporary table creation
Post #1467019
Posted Tuesday, June 25, 2013 6:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:36 PM
Points: 2,111, Visits: 122
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.


Thanks. I didn't know about the global. I guess I've never used one.
Post #1467109
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse