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 - 2002-12-30 : 05:03:15
|
| PARESH writes "I know if I pass table name as parameter in stored procedure I have to use Dynamic SQL statements & EXECUTE function to manipulate......I do not want to use EXECUTE as I have to update a lot many SP's created previously...It also needs manipulation in the variables other than varchar....." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-12-30 : 09:22:01
|
| You're pretty much limited to dynamic sql for this. |
 |
|
|
|
|
|
passing DB objects as parameter in stored procedure