l******9
发帖数: 579 | 1 I have to debug a store procedure on SQL server 2008 R2 on Microsoft sql
studio.
In my SQL query, I have to call two store procedures :
EXEC @return_value = [my_database].[dbo].[store_procedure1]
in [my_database].[dbo].[store_procedure1], I need to call another procedure:
execute @return_status = store_procedure2
in debugging mode of SQL server management studio, I can step into [store_
procedure1] but, I cannot step into [store_procedure2].
Any help would be appreciated. | m**c
发帖数: 199 | 2 这种问题应该去编程版，不适合在这里问
procedure:
【在 l******9 的大作中提到】
: I have to debug a store procedure on SQL server 2008 R2 on Microsoft sql
: studio.
: In my SQL query, I have to call two store procedures :
: EXEC @return_value = [my_database].[dbo].[store_procedure1]
: in [my_database].[dbo].[store_procedure1], I need to call another procedure:
: execute @return_status = store_procedure2
: in debugging mode of SQL server management studio, I can step into [store_
: procedure1] but, I cannot step into [store_procedure2].
: Any help would be appreciated.
|
|
