Search code examples
.netvisual-studio-2010visual-studio-debugging

Iterate in a watch for a SQL Parameter List

So for example. I have an SP which passes 10 parameters, which then throws back a truncate error when attempting to run, I'd like to debug in SQL Studio so I add a watch on the parameter list which returns (when I expand at the first level) a list of all the names of the items in the parameter list.

E.g.

 1.  @User_ID
 2.  @FirstName

 ....
 10. @Date_Updated

Now I would like to be able in the watch window iterate through these and show the .Value of each of these parameters without having to specifiy 10 watches each being:

myParameterList(0).Value
myParameterList(1).Value
...
myParameterList(9).Value

Is there a way to iterate through a list in the watch window on visual studio to help with debug?

Solution

  • It seems to be not possible (see), but here could be the solution.