How to see result of select during Sql Server debugging

Question

I am debugging a stored procedure in Sql Server, I can see the local variables in "Locals", I can add other variables in "Watches" (I have embedded a picture here with Sql Server in debug mode and different debug windows). My question is: where can I see the result of the select statements during debugging? It is really helpful to see them as they are executed, more so when they read from temporary tables sometimes, which are local to that procedure.

Later edit: I have followed the advice given below and am having this problem with XML viewer (please see attachment): "The XML page cannot be displayed"

SQL Server Profiler allows you to debug queries, have you looked into this? — JsonStatham
– JsonStatham, Commented Nov 11, 2015 at 8:47

Lukasz Szozda · Accepted Answer · 2015-11-11 08:45:30Z

1

From View contents of table variables and temp tables in SSMS debugger:

This won't be in immediately, but we are considering a feature similar to this for a future release.

And workaround (you need to add additional XML variable for each temp table):

Declare @TableVar_xml xml
Set @TableVar_xml = (Select * from @TableVar for XML Auto, Elements xsinil);

Then I can look at the table variable contents using the XML viewer.

answered Nov 11, 2015 at 8:45

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JD123456 Over a year ago

Thank you very much, lad2025! Unfortunately I receive an error: "The XML page cannot be displayed" (I have added the print screen in the original question). How do you use XML Viewer, can you please expand a little on this?

Lukasz Szozda Over a year ago

@JD123456 Try: Set @TableVar_xml = (Select * from @TableVar for XML Auto)

Lukasz Szozda Over a year ago

@JD123456 Does your @TableVar contain any rows?

Collectives™ on Stack Overflow

How to see result of select during Sql Server debugging

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related