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

sql debugging ssms table-variable
Faiz picture Faiz · Dec 14, 2009 · Viewed 102.7k times · Source

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

Answer

kirby picture kirby · Jul 19, 2011 
DECLARE @v XML = (SELECT * FROM <tablename> FOR XML AUTO)

Insert the above statement at the point where you want to view the table's contents. The table's contents will be rendered as XML in the locals window, or you can add @v to the watches window.

enter image description here

Related questions

Watching variables in SSIS during debug

I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I wanted to confirm the value because I was worried that it would try to write it out as …

Read More
Using bcp utility to export SQL queries to a text file

I debug a stored procedure (SQL Server 2005) and I need to find out some values in a datatable. The procedure is run by an event of the application and I watch just the debugging output. I do the following my …

Read More
cakephp see the compiled SQL Query before execution

My query gets the timeout error on each run. Its a pagination with joins. I want to debug the SQL, but since I get a timeout, I can't see it. How can I see the compiled SQL Query before execution? …

Read More