Shulou(Shulou.com)06/01 Report--

Preface

For some reason, the important DEBUGGER feature has been removed from SQLSERVER 2005. To debug, you must install VS2005 Professional or later. It's very inconvenient.

Fortunately, this important and convenient feature in SQLSERVER 2008 is back.

However, the debugging capabilities of SQLSERVER 2008 are quite different from the methods of SQL2000. SQL2000 is the stored procedure that needs to be debugged in the object browser in the query analyzer. Right-click-debug-input parameters to start debugging.

In sqlserver2008, it's completely different. You have to EXEC [PROCEDURE NAME] @ VAR1,@VAR2 in SSMS, and then click the green triangle or click debug in the menu-start debugging. Then click the rightmost step in the toolbar to debug or jump out, etc.

This article will give you a detailed introduction to sql server2008 debugging stored procedures. Let's take a look at the detailed introduction.

The method is as follows

1. Create the stored procedure you need to debug and execute it, that is, save it. The stored procedure I'm going to demonstrate is called "usp_Passport_GetNewDepositary".

2. Find the stored procedure, right-click "execute the stored procedure", and the following interface pops up to enter the parameters used by the stored procedure.

3. Click OK after entering the parameters, and the system will generate the following code to the editor for you.

4. Click the small green triangle on the toolbar to enter the debugging interface. Note that there is a key point. When the code is executed on the EXEC line, you must click "debug"-"statement by statement". Only in this way can you enter the stored procedure.

5. Let everyone have a look at the interface after entering, so that the parameters can be easily monitored.

Summary:

The above is the whole content of this article, I hope that the content of this article has a certain reference and learning value for your study or work, if you have any questions, you can leave a message and exchange, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.