MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

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