Is there a way to do debug stored procedure for SQL Azure?

Question

Normally you debug T-SQL logic on a local SQL Server database; that's the easiest way to debug. Running the stored proc locally allows you to step through your code and debug it easily. 31 янв. 2012 г.

How do I debug a stored procedure in Azure SQL?

Debugging options1Start Debugging. To start debugging a SQL server stored procedure in SQL Server, press ALT + F5, or go to Debug -> Start Debugging, as shown in the figure below: ... 2Stepping Through Script. ... 3Run To Cursor. ... 4The Local Window. ... 5The Watch Window. ... 6The Call Stack. ... 7The Immediate Window. ... 8Breakpoints.Debugging stored procedures in SQL Server Management Studio ...

How do I debug a stored procedure in Azure Data Studio?

Debug your extension1Press F5 or click the Debug icon and click Start.2A new instance of Azure Data Studio will start in a special mode ( Extension Development Host ) and this new instance is now aware of your extension.3Press ctrl+shift+P (Windows/Linux) or cmd+shift+P (macOS) and run the command named Hello World.Azure Data Studio Debug

Can we debug stored procedure?

To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.

Is there a debugger for SQL?

The Transact-SQL debugger provides the following options that you can use to navigate through Transact-SQL code when the Database Engine Query Editor window is in debug mode: Set breakpoints on individual Transact-SQL statements.

Expert · Answer