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: Friday, July 18, 2014 12:04 PM
Points: 2,186, Visits: 68
Comments posted to this topic are about the item Temp Table
Post #1466968
Posted Monday, June 24, 2013 10:40 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:07 AM
Points: 697, Visits: 928
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 6, 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: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
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: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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: Tuesday, September 9, 2014 3:27 AM
Points: 1,893, Visits: 2,329
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: Monday, July 21, 2014 3:43 AM
Points: 1,938, Visits: 1,162
Easy one

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 12:40 AM
Points: 384, Visits: 16
Its temporary table creation
Post #1467019
Posted Tuesday, June 25, 2013 6:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:39 AM
Points: 2,935, Visits: 239
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