l******9
发帖数: 579 | 1 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL debug step into a store procedure from another one
发信站: BBS 未名空间站 (Mon Jun 30 11:04:12 2014, 美东)
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. | s**********o
发帖数: 14359 | 2 还DEBUG，直接砍掉STORED PROC，改成QUERY+VALUE，RUN RUN 看了 |
|
