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