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 |
|
aex
Yak Posting Veteran
60 Posts |
 Posted - 2006-08-01 : 22:33:23
|
| I know that to pass a value from dynamic sql is to create a temporary table to hold the variable value. But I find that there is a limitation for that. For example, if there is a temp table called #VarValue to hold the return value and if there is one user who first invoke the sql, then #VarValue would available to that user. But this is not the case for subsequent user where #VarValue is already existed in database.Any opinion on this? Thanks.aex |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-01 : 22:40:10
|
temp table is local to connection. temp table created in one connection is not available to another connection. You can verify this using Query Analyser, open up 2 window and create the same temp table in both window.In your case, is it each user utlizing one connection ?
KH |
 |
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2006-08-01 : 22:52:15
|
Thanks thanks a lot khtan!!! You are right. I am working on single machine all the while and I do not realise the fact that the temp table is different for different connection.And reply to your question: each user is utilizing their own connection.Thanks again khtan.  aex |
|
|
|
|
|
|
Dynamic sql return value limitation?