Use if statement with LOOP statement
Conditional if statements in SQL are used to perform different actions based on different conditions.
Understand with Example
The Tutorial illustrate a example from if statement with LOOP statement. In this example we create a procedure display that accept no as input parameter and data type is int. The Begin Statement include a declare keyword that define the variable and its data type. The if and else is used to execute the code if the condition is true or the condition is false.