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, 3200🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...