sql-serverdebuggingsql-server-2012table-variablewatch-window

Viewing contents of table variable when debugging in sql server 2012


In the watch window whilst debugging in Sql Server 2012, we get to see the values of regular variables, we can look at xml in a special window and same with sql strings, but for a table variable it just says (table).

I'd really like to know if there is any way to peek inside that table variable at that moment and check on the contents.

EDIT:

I have discovered that Visual Studio (for a long time now), has had a "Table" visualizer alongside Xml, Html, and Text. This does not help me here, but it underscores the point I made originally that it is a very doable feature. I'm very disappointed in general with the Sql Server SSMS team vs the Visual Studio team. I think Visual Studio developers in Redmond ought to be forced every 5 years to do a "tour of duty" for 2 or 3 sprints on the SSMS team. They could help it sooo much if they did that.

Thank you.


Solution

  • No, I'm sorry to report that this is still not possible in SQL Server 2012. The feature has been requested, received a lot of upvotes, but was discarded after four years of deliberation:

    http://connect.microsoft.com/SQL/feedback/details/363054