Collections:
IF ... ELSE Statement in SQL Server Transact-SQL
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE statements?
✍: FYIcenter.com
You can use IF ... ELSE statements to execute statements under given conditions in Transact-SQL using these syntaxes:
IF condition statement_1 IF condition statement_1 ELSE statement_2 IF condition -- statement_block_1 BEGIN ... statements ... END IF condition -- statement_block_1 BEGIN ... statements ... END ELSE -- statement_block_2 BEGIN ... statements ... END
When a IF...ELSE statement is executed, the system will:
Here is an example on how to use IF ... ELSE conditional statements:
IF DATENAME(weekday, GETDATE()) IN ('Saturday', 'Sunday') BEGIN PRINT 'It''s a weekend.'; PRINT 'You can stay home.'; END ELSE BEGIN PRINT 'It''s a weekday.'; PRINT 'You need to go to work.'; END
⇒ "IF ... ELSE IF ..." Statement Structures in SQL Server
⇐ BEGIN ... END Statement Blocks in SQL Server Transact-SQL
⇑ Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
2017-01-11, 3223🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...