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 1234»»»

Temp Table Data Types Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 8:25 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:58 AM
Points: 1,888, Visits: 1,864
Comments posted to this topic are about the item Temp Table Data Types
Post #1430184
Posted Tuesday, March 12, 2013 8:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 5,472, Visits: 23,549
Nice question .. learned something from it ... thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1430186
Posted Tuesday, March 12, 2013 9:53 PM


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
bitbucket-25253 (3/12/2013)
Nice question .. learned something from it ... thanks


+1
Thanks Dave


~ 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 #1430199
Posted Tuesday, March 12, 2013 10:20 PM
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
bitbucket-25253 (3/12/2013)
Nice question .. learned something from it ... thanks


+1

I gotta learn about Select Into ; as I mostly avoid it , I don't pay attention ...
I guessed for Varchar and Date
time for research

thanks for the question


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1430201
Posted Tuesday, March 12, 2013 11:18 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:42 PM
Points: 20,473, Visits: 14,120
Nice question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1430210
Posted Tuesday, March 12, 2013 11:37 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
demonfox (3/12/2013)
bitbucket-25253 (3/12/2013)
Nice question .. learned something from it ... thanks


+1

I gotta learn about Select Into ; as I mostly avoid it , I don't pay attention ...
I guessed for Varchar and Date
time for research

thanks for the question


Same here. Good learning. !!!




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

Post #1430221
Posted Tuesday, March 12, 2013 11:51 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: Wednesday, April 16, 2014 5:16 AM
Points: 905, Visits: 553
One easiest way to avoid this confusion is .. don't use SELECT * INTO.

Always prefer CREATE TABLE..


--
Dineshbabu
Desire to learn new things..
Post #1430227
Posted Wednesday, March 13, 2013 1:32 AM


SSC Eights!

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

Group: General Forum Members
Last Login: Monday, February 24, 2014 6:09 AM
Points: 827, Visits: 1,360
Learned something new here, and by the way, the reference should be:

Date, Time, and Timestamp Escape Sequences




Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1430244
Posted Wednesday, March 13, 2013 1:59 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:39 AM
Points: 2,397, Visits: 2,287
okbangas (3/13/2013)
Learned something new here, and by the way, the reference should be:

Date, Time, and Timestamp Escape Sequences

Good!
Post #1430247
Posted Wednesday, March 13, 2013 2:07 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 3,690, Visits: 4,822
Interesting question, thanks Dave

Another way to check the detail of the temp table would be to execute
tempdb..sp_help #TempQoD



____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1430248
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse