Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Debug SQL > Work with Watches > View Local Watches

View Local Watches

Use the Local Watches window to automatically display watches for all local variables and parameters within the current procedure context.

Note: You cannot add or remove watches from this window.

To view local watches

Select Debug | Windows | Local Watches from the menu.

Tips:

You can set an option so function calls are not evaluated when hovering the cursor over watches in Debugger Options (Tools | Options | Editor | Debugger).

When the current context changes, the Local Watches window evaluates the updated contents.
Watches display in a tooltip in the Editor window when you place the cursor over an expression. In some cases, you may need to highlight the expression to evaluate more complicated expressions such as ”r;@x+10” or ”r;substring(@sVal, 1, 10)”.