How do you debug SP?

jemz · January 1, 2015, 1:02pm

Hi,can I ask ?. How do you debug your stored procedure ? that you can see the execution line by line of your code…I’m still learning creating stored procedure but I don’t know how to debug my code line by line that I can see the result or the value of my variable that I used…Is there a software to use with this ?

Thank you in advance.

John_Betong · January 1, 2015, 2:27pm

Maybe try a different approach and build the query a line at a time until it breaks:)

jemz · January 1, 2015, 3:59pm

Thank you for the reply @John_Betong

system · April 2, 2015, 11:12pm

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.