Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?

Asked 14-Sep-2021
Viewed 768 times

0

Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?


1 Answer


0

SQL IF –ELSE Statement:
In the SQL Server, IF –Else statement is used to execute the particular SQL statement. It is a conditional statement in which that statement is execute where condition is satisfied. If – else statement returns the Boolean expression. If the condition is true inside the IF statement then the block of statements is executed of IF Statement otherwise if the condition is not true then the block of statement is executed of Else statement.
Syntax –
        IF condition
            block of statements is executed if the condition is true.
        ELSE
            block of statement is executed if the condition is false.
Note - you can remove the ELSE statement from IF condition because ELSE is optional and it execute when the condition inside the IF statement is false.
Example:
         Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?
If you want to execute multiple statements inside the IF and ELSE statement then you need to use BEGIN and END inside the IF and ELSE statements.
         Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?
We can also used SQL command in IF ELSE statement to execute the record as needs
    Lets have a database table ‘Employees’
          Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?
The following SQL IF- ELSE statement is used to find the sum of salary of Employees from ‘Employees’ table. If the salary is more than 30000 then it returns the name AS Engineers and if salary is less than 30000 then it returns the name AS Training.
    DECLARE @value INT;
    select @value=SUM(Salery) from Employees
    IF(@value>30000)
    BEGIN
     select EmpName AS Engineer,Salery from Employees;
    END
    ELSE
    BEGIN
    select EmpName AS Trainning, Salery from Employees;
    END;
        Why are use the IF-ELSE statement in the database how to validate the database using IF-ELSE?