Tutorialspoint.dev

SQL SERVER | Conditional Statements

While loop: In SQL SERVER, while loop can be used in similar manner as any other programming language. A while loop will check the condition first and then execute the block of SQL Statements within it as long as the condition evaluates true.

Syntax:

WHILE condition
BEGIN
   {...statements...}
END;

Parameters:
1. Condition: The condition is tested in each pass through the loop. If condition evaluates to TRUE, the loop body is executed otherwise the loop is terminated.
2. Statements: The statements that needs to be executed in each pass through the loop.

Example:

Output:



Break statement: BREAK statement as the name signifies is used to break the flow of control. It can be used in SQL in similar manner as any other programming language.

Example: While loop with Break statement

Output:

Note : In the example, when variables value became five, BREAK Statement is executed and the control gets out from the Loop.

Do-While loop: SQL server does not have the feature of do-while loop but by doing little modifications in while loop, the same behaviour can be achieved.

Example 1:

Output:

Example 2:

Output:

CASE statement: In SQL Server, the CASE statement has the same functionality as IF-THEN-ELSE statement.

Syntax:

CASE Expression
   WHEN Con_1 THEN Output1 
   WHEN Con_2 THEN Output2
   WHEN Con_3 THEN Output3
   WHEN Con_4 THEN Output4
   ...
   WHEN Con_n THEN Outputn
   ELSE output
END

Paramaters:
1. Expression: The value to be compared to the list of conditions(Optional).
2. Con_1, Con_2, …Con_n: The conditions are required and are evaluated in the order they are listed. Once a condition is true, the CASE function will return the result and not evaluate the conditions any further.
3. Output1, Output2, …Outputn: The output to be printed once the condition evaluates true.

Example:

Output:



This article is attributed to GeeksforGeeks.org

leave a comment

code

0 Comments

load comments

Subscribe to Our Newsletter