How to see the values of a table variable at debug

Question

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?

Answer 1

Why not just select the Table and view the variable that way?

SELECT * FROM @d

Answer 2

Sorry guys, I'm a little late to the party but for anyone that stumbles across this question at a later date, I've found the easiest way to do this in a stored procedure is to:

1. Create a new query with any procedure parameters declared and initialised at the top.
2. Paste in the body of your procedure.
3. Add a good old fashioned select query immediately after your table variable is initialised with data.
4. If 3. is not the last statement in the procedure, set a breakpoint on the same line, start debugging and continue straight to your breakpoint.
5. Profit!!

messi19's answer should be the accepted one IMHO, since it is simpler than mine and does the job most of the time, but if you're like me and have a table variable inside a loop that you want to inspect, this does the job nicely without too much effort or external SSMS plugins.

Answer 3

That's not yet implemented according this Microsoft Connect link: Microsoft Connect