Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Collapse Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

Conditional Processing

 
* If..Else : IF part executed when condition is TRUE; ELSE part executed when the 'IF' condition is not satisfied.

* Simple Case : The simple CASE function compares an expression to a set of simple expressions to determine the result.

* Searched Case : The searched CASE function evaluates a set of Boolean expressions to determine the result.

* GOTO : Alters the flow of execution to a label. Statements that follow GOTO are skipped and processing continues at the label.