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 |