Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Today @ 11:07 AM
Points: 2,900, Visits: 2,687
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: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
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: Today @ 8:20 AM
Points: 1,386, Visits: 1,590
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: Tuesday, October 11, 2016 10:43 AM
Points: 1,145, Visits: 1,191
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: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
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, July 23, 2015 2:40 AM
Points: 1,242, Visits: 1,549
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 5, 2015 4:29 AM
Points: 1,028, Visits: 569
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: Sunday, November 22, 2015 11:42 PM
Points: 907, Visits: 1,387
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


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: Monday, November 28, 2016 1:13 AM
Points: 3,367, Visits: 3,190
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 5,356, Visits: 7,064
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