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
Concepts
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)