In this article, we will learn how to use the If-Else statement in SQL.
In SQL, the If-Else statement executes a block of code if a specified condition is true. If the condition is false, else block of code can be executed.
The If-Else statement is a part of SQL’s conditional Statements. Conditional Statements are used to perform different actions based on different conditions in SQL.
IF <Condition> BEGIN -- Statement block executes when the Condition is TRUE. END ELSE BEGIN -- Statement block executes when the Condition is FALSE. END
If the number of students is under 100 in the StudentInfo table the subsequent statement would print ex. ‘Number of Students: 67’ else it would print ‘Number of Students: >= 100’
BEGIN DECLARE @count INT = 0; SELECT @count = count(*) FROM StudentInfo; IF @count < 100 BEGIN PRINT 'Number of Students: ' + CAST(@count AS VARCHAR); END ELSE BEGIN PRINT 'Number of Students: >= 100'; END END
Also, check How To Write Insert Into Select Query In SQL