We can use multiple IF statement to check multiple expressions totally independent from each other.
In the example below, each
IF statement's expression is evaluated and if it is true the code inside the
BEGIN...END block is executed. In this particular example, the First and Third expressions are true and only those print statements will be executed.
IF (1 = 1) --<-- Some Expression --<-- This is true BEGIN PRINT 'First IF is True' --<-- this will be executed END IF (1 = 2) --<-- Some Expression BEGIN PRINT 'Second IF is True' END IF (3 = 3) --<-- Some Expression --<-- This true BEGIN PRINT 'Thrid IF is True' --<-- this will be executed END