1. <tfoot id='vrrdl'></tfoot>
      2. <i id='vrrdl'><tr id='vrrdl'><dt id='vrrdl'><q id='vrrdl'><span id='vrrdl'><b id='vrrdl'><form id='vrrdl'><ins id='vrrdl'></ins><ul id='vrrdl'></ul><sub id='vrrdl'></sub></form><legend id='vrrdl'></legend><bdo id='vrrdl'><pre id='vrrdl'><center id='vrrdl'></center></pre></bdo></b><th id='vrrdl'></th></span></q></dt></tr></i><div id='vrrdl'><tfoot id='vrrdl'></tfoot><dl id='vrrdl'><fieldset id='vrrdl'></fieldset></dl></div>
      3. <legend id='vrrdl'><style id='vrrdl'><dir id='vrrdl'><q id='vrrdl'></q></dir></style></legend>
          <bdo id='vrrdl'></bdo><ul id='vrrdl'></ul>
      4. <small id='vrrdl'></small><noframes id='vrrdl'>

        调试 SQL Server 2008 中的存储过程

        Debugging Stored Procedure in SQL Server 2008(调试 SQL Server 2008 中的存储过程)

          <bdo id='EK54b'></bdo><ul id='EK54b'></ul>
          • <legend id='EK54b'><style id='EK54b'><dir id='EK54b'><q id='EK54b'></q></dir></style></legend>
            • <i id='EK54b'><tr id='EK54b'><dt id='EK54b'><q id='EK54b'><span id='EK54b'><b id='EK54b'><form id='EK54b'><ins id='EK54b'></ins><ul id='EK54b'></ul><sub id='EK54b'></sub></form><legend id='EK54b'></legend><bdo id='EK54b'><pre id='EK54b'><center id='EK54b'></center></pre></bdo></b><th id='EK54b'></th></span></q></dt></tr></i><div id='EK54b'><tfoot id='EK54b'></tfoot><dl id='EK54b'><fieldset id='EK54b'></fieldset></dl></div>
              <tfoot id='EK54b'></tfoot>

              <small id='EK54b'></small><noframes id='EK54b'>

                    <tbody id='EK54b'></tbody>

                1. 本文介绍了调试 SQL Server 2008 中的存储过程的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  有什么方法可以调试 SQL Server 2008 上的存储过程?

                  Is there any way to debug a stored procedure on SQL Server 2008?

                  我有权使用 SQL Server Management Studio 2008 和 Visual Studio 2008(不确定两者是否提供此功能).

                  I have access to use SQL Server Management Studio 2008 and Visual Studio 2008 (not sure whether either provides this functionality).

                  通常我使用 SQL 分析器来查找传递给存储过程的参数,但是希望能够逐步执行该过程以查看它在哪里失败.

                  Generally I use the SQL profiler to find the parameters passed to the stored proc, however would like to be able to step through the procedure to see where it is failing.

                  这可能吗?

                  最好的方法是什么?(在快速查找bug位置方面)

                  What is the best way? (in terms of quickly finding location of bugs)

                  推荐答案

                  答案一直就在我面前.

                  在 SQL Server Management Studio 2008 中,工具栏中有一个调试按钮.在查询窗口中设置断点以单步执行.

                  In SQL Server Management Studio 2008 there is a Debug button in the toolbar. Set a break point in a query window to step through.

                  我一开始就忽略了这个功能,因为我没有想过进入存储过程,你可以轻松地做到这一点.

                  I dismissed this functionality at the beginning because I didn't think of stepping INTO the stored procedure, which you can do with ease.

                  SSMS 基本上会自动执行 FinnNK 在 MSDN 演练中提到的内容.

                  SSMS basically does what FinnNK mentioned with the MSDN walkthrough but automatically.

                  太简单了!感谢您的帮助 FinnNK.

                  So easy! Thanks for your help FinnNK.

                  我应该在那里添加一个步骤来查找我在数据库上使用 SQL Profiler 的参数的存储过程调用.

                  I should add a step in there to find the stored procedure call with parameters I used SQL Profiler on my database.

                  这篇关于调试 SQL Server 2008 中的存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Building a comma separated list?(建立一个逗号分隔的列表?)
                  Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column(尽管每列都使用了 varchar(MAX),但在导入 CSV 文件时 SQL Server 中出现错误)
                  How can I import an Excel file into SQL Server?(如何将 Excel 文件导入 SQL Server?)
                  Export table to file with column headers (column names) using the bcp utility and SQL Server 2008(使用 bcp 实用程序和 SQL Server 2008 将表导出到带有列标题(列名称)的文件)
                  Concat field value to string in SQL Server(将字段值连接到 SQL Server 中的字符串)
                  SQL Server Bulk insert of CSV file with inconsistent quotes(SQL Server 批量插入带有不一致引号的 CSV 文件)
                    <bdo id='T9AsY'></bdo><ul id='T9AsY'></ul>
                      <tbody id='T9AsY'></tbody>
                  • <tfoot id='T9AsY'></tfoot>

                      1. <legend id='T9AsY'><style id='T9AsY'><dir id='T9AsY'><q id='T9AsY'></q></dir></style></legend>
                      2. <small id='T9AsY'></small><noframes id='T9AsY'>

                        <i id='T9AsY'><tr id='T9AsY'><dt id='T9AsY'><q id='T9AsY'><span id='T9AsY'><b id='T9AsY'><form id='T9AsY'><ins id='T9AsY'></ins><ul id='T9AsY'></ul><sub id='T9AsY'></sub></form><legend id='T9AsY'></legend><bdo id='T9AsY'><pre id='T9AsY'><center id='T9AsY'></center></pre></bdo></b><th id='T9AsY'></th></span></q></dt></tr></i><div id='T9AsY'><tfoot id='T9AsY'></tfoot><dl id='T9AsY'><fieldset id='T9AsY'></fieldset></dl></div>