How to debug a stored procedure in sql server 2008

Question

I newly joined as a Trainee.. Can anybody help me?.. how to solve issues that raises in stored procedure.  Any methods or techniques to find the bugs in a stored procedure..

Answer 1

first of all make a store procedure well format. if you want debug the store procedure then just select the store procedure like this way.


create proc procedureName
()
as 
begin


end


if you want debug any store procedure select the procedureName and press the CTRL+F5. your studio convert to in debug. 

Answer 2

Go through following links it will help you

https://msdn.microsoft.com/en-US/library/yet1b7by%28v=vs.80%29.aspx

http://stackoverflow.com/questions/1793612/debugging-stored-procedure-in-sql-server-2008