How do you debug SP?

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.

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

Thank you for the reply @John_Betong

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