How to debug T-SQL with SQL Server Management Studio 2017?

sql-server tsql debugging ssms ssms-2017
WΩLLE - ˈvɔlə picture WΩLLE - ˈvɔlə · Mar 28, 2019 · Viewed 8.5k times · Source

The latest changelog (18.0 Preview 7) of SQL Server Management Studio announced, that the T-SQL Debugger is deprecated.

What are the alternatives for the future? Can someone understand this decision? I fear that removing a fundamental development tool like this will effect many developers.

Answer

Dens picture Dens · May 22, 2019

You just need to download the Visual Studio 2019 Community.

Once you've done that, create a new project and open the SQL Server Object Explorer (CTRL + S).

You will be able to see your list of SQL Server databases, just as you did in SQL Server Management Studio.

Finally, left click one database and select "New Query". Now you can debug T-SQL just as you did in SSMS.

Related questions

How to debug SQL Server T-SQL in Visual Studio 2012

How does one debug a T-SQL stored procedure in a multi-tier application in Visual Studio 2012? To be clear, I want to set a breakpoint in a sproc in VS 2012, and hit it when the sproc is called from an ASP.…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More