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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-26 : 09:40:46
|
| Jose Miguel writes "Hi, In one Stored procedure I create one temporal table(2 columns), and added two more columns with "alter table #paso add newcolumn int". If I do select * from #paso the columns apperas ok, but when I try to update the new column the follow error occurs: Column not exists...Why?" |
|
|
btrimpop
Posting Yak Master
214 Posts |
Posted - 2001-11-26 : 16:14:47
|
| A quick thought, is the alter table wrapped in a transaction that has not been commited yet?"In theory there is no difference between theory and practice. But in practice there is!" |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-11-26 : 22:12:46
|
| Temp tables only exist for the current connection. If you change connections with your update statement, the table won't be there. |
|
|
|
|
|
|
Alter #table