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 |
|
rohitgraycell
Starting Member
8 Posts |
 Posted - 2006-04-21 : 05:10:04
|
| I am executing a stored procedure from within other procedure with EXEC SPname Command. I have read that we should use sp_ExecuteSql system stored procedure in place of EXEC command because it will catch the execution plan whereas executing a statement or a stored procedure will not catch the execution plan. Now i am trying to execute my stored procedure as Execute Sp_ExecuteSql @parameterName from within another stored procedurewhere @paramter is an integer (but internet says that sp_executesql only accepts nvarchar/ntext datatype).So i am not able to really execute my stored procedure with sp_ExecuteSql. Am i missing out something..is there some prodedure to do this task???ANY HELP WILL BE GREATLY APPRECIATED.THANKS |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
passing paramter to sp_ExecuteSql