title: How to view data in table variables during debugging session in MS SQL Management Studio 2012?
body: <p>I would like to debug a complex T-SQL script using SSMS 2012. </p>
  
  <p>I can run the script in debug mode and place breakpoints, as well as step through my script, but I can't see the values stored in my table variables.</p>
  
  <p>In the <code>Locals</code> window I see all these variables, but their value is shown as <code>(table)</code>:</p>
  
  <p><img src="https://i.stack.imgur.com/ixToB.png" alt="Locals window"></p>
  
  <p>There is no way to view the content of the variable through the context menu or by clicking on the variable.</p>
  
  <p>I tried to use the <code>Immediate Window</code> to run a query on the table variable, but this seems not to work either.</p>
  
  <p><img src="https://i.stack.imgur.com/03x01.png" alt="Immediate Window"></p>
  
  <p>Any idea how I can get the values from my table variables in the debug session?</p>