Debug the Stored Procedure OR Functions in SQL?

Do you know how to debug the stored procedure OR functions in SQL?

Here the way you can debug you stored procedure and function.

Steps to debug the stored procedure/ function :

Step 1 : Create a web project/windows project according to your preference
Step 2 : Connect to your database server through server Explores (See below screenshot)
Step 3 : Expand your stored procedure/Function
Step 4 : open the procedure/ function and set breakpoint
Step 5 : Now Right click on the stored procedure / function you want to debug
Step 6 : Click on Step into stored procedure/ function
Step 7 : Set default parameter values

Now it will take to you break point.
See the screen shot below

No comments: