How to see the values of a table variable at debug time in T-SQL?

user_82961 0
Viewed 111215

Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during debug time? If yes, how?

enter image description here

table-variable ssms sql debugging
9 Answers

If you are using SQL Server 2016 or newer, you can also select it as JSON result and display it in JSON Visualizer, it's much easier to read it than in XML and allows you to filter results.

DECLARE @v nvarchar(max) = (SELECT * FROM Suppliers FOR JSON AUTO)

enter image description here

user_30740220

I have come to the conclusion that this is not possible without any plugins.

user_829610
Related