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, 3240🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...