If Showplan Operator

The If operator carries out conditional processing based on an expression. If is a language element.

If language element iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)
Using IF...ELSE

Other Resources

IF...ELSE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance