How to debug sql in visual studio

Question

Is there a way of debugging sql in visual studio

Answer 1

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 simply open a stored procedure, set a breakpoint and run the stored procedure from visual studio with your parameters.

Didn't do that for a couple of time, but i am sure it works on any way from visual studio with stored procedures. Debugging a normal SQL command works in SQL server management studio, don't know if it work with visual studio.