Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zubairmasoodi
Starting Member
35 Posts |
 Posted - 2007-04-23 : 07:04:07
|
| hi allStuck with a problem of how to get the column informaion of Temporary Table that i Create dynamically in a Procedure . I tried with SP_CLOUMNS inbuilt procedure but that didnt helpany help is greately acknowledged Thanks in Advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-23 : 07:06:28
|
[code]select *from tempdb..syscolumns where id = object_id('tempdb..#temptable')[/code]
KH |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-23 : 07:08:40
|
Or this:EXEC tempdb..sp_columns '#temptable' Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
zubairmasoodi
Starting Member
35 Posts |
Posted - 2007-04-23 : 07:50:56
|
| HI Harsh Athalye and khtanI extend my sincere Thanks to both of u. I acn do it Now Thanks |
|
|
|
|
|
|
Temporary Tables