While Showplan Operator

The While operator implements the Transact-SQL while loop. While is a language element.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

WHILE (Transact-SQL)

Concepts

Logical and Physical Operators Reference

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)