All geek questions in one place

How to debug stored procedures in SQL Azure?

I am working on SQL Azure and have written several stored procedures. Now, while executing this stored procedure using an EXEC query from the database, I need to debug it to find the error, if any. Is there a way to do this in SQL Azure?

Note. - I am using Azure SQl on SQL Server 2008 R2.

+4
source share
1 answer

You typically debug T-SQL logic in a local SQL Server database; which is the easiest way to debug. Running a saved proc locally allows you to easily execute your code and easily debug it.

If for some reason the problem appears only in SQL Azure, you may need to add some instructions that register what happens during the call to the stored procedure, and work on this problem.

+1
source

Source: https://habr.com/ru/post/1394004/

More articles:


All Articles