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: Monday, December 15, 2014 2:27 AM
Points: 2,289, Visits: 69
Comments posted to this topic are about the item Temp Table
Post #1466968
Posted Monday, June 24, 2013 10:40 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 8, 2014 5:37 AM
Points: 749, Visits: 967
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, December 11, 2014 9:19 PM
Points: 1,129, Visits: 1,164
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, December 2, 2014 9:20 AM
Points: 1,372, Visits: 1,567
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: Today @ 4:17 AM
Points: 1,962, Visits: 2,407
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: Tuesday, November 25, 2014 11:09 PM
Points: 1,940, Visits: 1,173
Easy one

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

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 2:44 PM
Points: 1,282, Visits: 378
Perfect question for the morning after a night with little sleep

Cheers,

Steve
Post #1467121
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse