debug and unit test support with local variables
Within SQL Server Management Studio 2012, while debugging and stepping through a stored procedure source code many levels deep, one has access to the local variables pane. That pane shows variable name, value, and then type. That pane is so close to being helpful, yet it falls short by having the value and type in the wrong order.
It would be great to be able to copy the whole local panel and paste that as source to an editor as DECLARE @<variable name> <type>=<value> for each of the local variables.
That would greatly facilitate recreation of the cases that one is trying to debug without having to dig through many calls deep.
Call it capture the locals! :)