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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:12 AM
Points: 2,180, Visits: 2,173
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: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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: Tuesday, December 2, 2014 9:20 AM
Points: 1,372, Visits: 1,567
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: Thursday, December 11, 2014 9:19 PM
Points: 1,129, Visits: 1,164
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Nice question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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 6, 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: Monday, December 1, 2014 4:08 AM
Points: 987, Visits: 567
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: Friday, November 21, 2014 1:19 AM
Points: 846, Visits: 1,381
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: Yesterday @ 12:49 AM
Points: 2,620, Visits: 2,467
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:51 AM
Points: 4,158, Visits: 5,556
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