How to debug sql in visual studio

There is a way to debug stored procedures in visual studio running on SQL server. You can establish a connection to your SQL server through the Servers tab. Then just open the stored procedure, set a breakpoint, and start the stored procedure from visual studio with your parameters.

Haven't done this a couple of times, but I'm pretty sure it works from visual studio with stored procedures. Debugging normal SQL command works in SQL server management studio, don't know if it works with visual studio.