Specify a Breakpoint Condition
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
A breakpoint condition is a Transact-SQL expression that is evaluated by the debugger when the breakpoint is reached. If the condition is satisfied and any specified hit count reached, the debugger either breaks or performs the action specified for the breakpoint.
The expression specified must be a valid Transact-SQL expression that evaluates to a Boolean value. For more information, see Expressions (Transact-SQL).
If you specify a breakpoint condition with invalid syntax, a warning message appears immediately. If you specify a condition with valid syntax but invalid semantics, a warning message is displayed the first time the breakpoint is hit. In either case, the debugger breaks execution when the invalid breakpoint is hit.
To Specify a Condition
In the editor window, right-click the breakpoint glyph, and then click Condition on the shortcut menu.
In the Breakpoints window, right-click the breakpoint glyph, and then click Condition on the shortcut menu.
In the Breakpoint Condition dialog box, enter a valid Boolean expression in the Condition box.
Choose Is true if you want to break when the expression evaluates to true, or choose Has changed if you want to break when the value of the expression has changed.
The debugger does not evaluate the Boolean expression until the first time the breakpoint is reached. If you choose Has changed, the debugger does not consider the first evaluation to be a change, so the debugger will not break on the first evaluation.