Steve writes in a comment:
"(...) if you look at a string in the debugger trace window, it is truncated..
so if you happen to have a very long sql statment in hte string , or cannot view it, or even edit it"
so if you happen to have a very long sql statment in hte string , or cannot view it, or even edit it"
Indeed,
that's correct: as for any array, the debugger will only show 100
elements at a time, for performance reasons, as it may be very
expensive to send an unlimited value from the debuggee process to the
debugger.
So we only display the first 100 characters of a String.
For example, suppose the following code:
(...)
StringBuilder sb = new StringBuilder();
sb.append("This String has exactly 100 characters and you can check that all characters are displayed in debug");
sb.append("* * * However this text won't be visible in the Debug Data window * * *");
sb.append("* * *as it's after the limit of the 100 characters * * *");
(...)
In the debugger, you will only see the first 100 characters:

However, it's possible to see the whole value:
- right-click the value in the Data window
- select "View Whole Value..."
- now you can see the whole value
And for what concerns the arrays, you can select menu "Adjust Range..." if you want to display more elements:
