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 |
|
yenny.lauw
Starting Member
14 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 01:04:12
|
| USE TempDBsp_help #MyTempTablePeter LarssonHelsingborg, Sweden |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-04 : 01:05:38
|
tempdb..sp_help #tablename
KH |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-04 : 01:06:47
|
 Peso, you are fast
KH |
|
|
|
yenny.lauw
Starting Member
14 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-04 : 01:35:50
|
How do you create the table and how do you run the script ?
create table #temptable( col int, col2 datetime)exec tempdb..sp_help #temptabledrop table #temptable
KH |
|
|
|
yenny.lauw
Starting Member
14 Posts |
Posted - 2006-10-04 : 02:20:04
|
| hi khtan,thx for replying, I just realized that I open new session to run the sp_help #tablename, this is why query anaylzer keep saying table not found, but if I run the command on the same session, it works.thx a lot to you allCowboy | Alopecia Areata | Fold T-Shirt Fast | Naked in 7 seconds |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-04 : 02:32:29
|
quote:
Originally posted by yenny.lauw
hi khtan,thx for replying, I just realized that I open new session to run the sp_help #tablename, this is why query anaylzer keep saying table not found, but if I run the command on the same session, it works.thx a lot to you allCowboy | Alopecia Areata | Fold T-Shirt Fast | Naked in 7 seconds
temp table is per connection. So a new sesion in QA is a different connection.
KH |
|
|
|
|
|
|
|
|
Temporary Table Structure