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..