Graphic introduction to SQL stored procedure debugging with

Have you ever found any errors in the stored procedure? It may take a long time to read the SQL code and find a small error. This introduction uses vs2010 to debug the stored procedure, it's as good as debugging code in.

First, open vs and click View> server resource manager.

Select data connection, right-click, and click Add connection

Select the server and database of the stored procedure

Select the stored procedure to debug, right-click, and select single-step debug

Vs requires parameter values.

Then go to the single-step debugging. after entering the single-step debugging, You can monitor the variable value like debugging C # Or vb.net code. If the trigger is involved in the execution process, it also jumps into the trigger and executes the trigger code.

Monitoring variables:

Now, you can debug the stored procedure just like debugging an application.