Stewart "Arturius" Campbell (3/13/2013)

---

Interesting question, thanks Dave

Another way to check the detail of the temp table would be to execute

tempdb..sp_help #TempQoD

Carlo Romagnano (3/13/2013)

---

Good!

Raghavendra Mudugal (3/13/2013)

---

Now this is very very new thing to me... thank you.

(and for the INTO.. table stuff, I thought it is obvious... like when you use the import/export tool and when you trying to import the data from the excel file it marks all the column as varchar except the first one if there are any number like 1 2 3... it marks as int... and if we need the col type to any specific then the tool allows us to modify the value accordingly. As the source data is like a variant, I thought it will be difficult to sql to pick the exact datatype to meet the source and the destiny.... until proven otherwise. This is very interesting, thank you for posting the question, Dave)

Stewart "Arturius" Campbell (3/13/2013)

---

Interesting question, thanks Dave

Another way to check the detail of the temp table would be to execute

tempdb..sp_help #TempQoD

Stewart "Arturius" Campbell (3/13/2013)

---

Interesting question, thanks Dave

Another way to check the detail of the temp table would be to execute

tempdb..sp_help #TempQoD

USE tempdb;
go
SELECT *
FROM  sys.objects o 
      LEFT JOIN sys.columns AS c ON c.object_id = o.object_id
      LEFT JOIN sys.types AS t ON t.system_type_id = c.system_type_id       
WHERE o.object_id = object_id('#TempQoD');

bitbucket-25253 (3/12/2013)

---

Nice question .. learned something from it ... thanks