如何在存储过程中逐行调试 [英] How to debug line by line in stored procedure

问题描述

我正在使用SQL server2012来编写存储过程。我想调试每行代码。我在我的存储过程中设置了一个断点。但是在我的sql server中，在调试时，调试器从头到尾选择所有代码并一次执行代码。所以我无法逐行检查代码。我如何在sql server 2012中修复此问题？

I am using SQL server2012 to write stored procedure.I wanted to debug each line of code. I set a breakpoint in my stored procedure.however in my sql server, at time of debugging,debugger selects all code from beginning to end and executes code at one go.So i am not able to check codes line by line. How can i fix this in sql server 2012?

推荐答案

从这里开始：

演练：调试Transact-SQL存储过程 [ ^ ]



http://sqlmag.com/visual-studio-2010/debugging -stored-procedures-visual-studio-2010 [ ^ ]

Start here :
Walkthrough: Debug a Transact-SQL Stored Procedure[^]

http://sqlmag.com/visual-studio-2010/debugging-stored-procedures-visual-studio-2010[^]

其他链接 -

如何在Visual Studio .NET中调试存储过程 [ ^ ]

调试SP [ ^ ]

调试存储过程 [ ^ ]

Additional links -
How to debug stored procedures in Visual Studio .NET [^]
Debugging SP's[^]
Debugging Stored Procedures[^]

这篇关于如何在存储过程中逐行调试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！