DATABASE & SQL/PLSQL

The IF...ELSE Statement and BEGIN...END Statement
Previous Home Next

IF...ELSE Statement

Syntax:

IF  boolean_expression
    {sql_statement}
ELSE  boolean_expression
    {sql_statement}
    

where, boolean_expression is the condition that evaluates to either TRUE or FALSE.

sql_statement is any T-SQL statement.

statement_block is a collection of T-SQL statements.

 

BEGIN...END Statement

Syntax:

BEGIN
     {sql_statement}
END

where, sql_statement is one or more SQL statements

The BEGIN...END block is nested and is most often used with the IF...ELSE statement and the WHILE looops.

Example:

IF EXISTS (SELECT  *  FROM  employee  WHERE  emp_name='anchal')
BEGIN
      PRINT  'The Details of employee are Available'
      SELECT  *  FROM employee  WHERE  emp_name='anchal'
END
ELSE
      PRINT  'Employee details not Available'

output

IF EXISTS (SELECT  *  FROM  employee  WHERE  emp_name='anchal')
BEGIN
      PRINT  'The Details of employee are Available'
      SELECT  *  FROM employee  WHERE  emp_name='Ram'
END
ELSE
      PRINT  'Employee details not Available'

Example: There are number of employee in the employee table and there salary different according to there experience, the administrator want to increase there salary then this code be written.

SELECT  *  FROM employee

output

IF (SELECT MAX (emp_sal)  FROM  employee )<45000
BEGIN
     UPDATE employee
     SET emp_sal=emp_sal+25000
END
ELSE
BEGIN
     UPDATE  employee
     SET  emp_sal=emp_sal+10000
END
SELECT  *  FROM employee

output

Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: