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: Wednesday, August 5, 2015 6:00 AM
Points: 2,541, Visits: 75
Comments posted to this topic are about the item Temp Table
Post #1466968
Posted Monday, June 24, 2013 10:40 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 30, 2015 1:00 AM
Points: 804, Visits: 1,015
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: Yesterday @ 5:34 AM
Points: 307, Visits: 595
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, July 23, 2015 2:40 AM
Points: 1,242, Visits: 1,549
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: Tuesday, April 21, 2015 11:20 AM
Points: 1,129, Visits: 1,167
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, August 19, 2015 1:14 AM
Points: 1,378, Visits: 1,574
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 20, 2015 12:21 AM
Points: 2,078, Visits: 2,647
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, July 29, 2015 11:50 PM
Points: 1,967, Visits: 1,189
Easy one

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1467017
Posted Tuesday, June 25, 2013 2:02 AM
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: 2 days ago @ 6:36 AM
Points: 735, Visits: 18
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: Tuesday, March 17, 2015 8:35 AM
Points: 1,290, Visits: 387
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