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
Â
⇒Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
2017-01-11, 2538👍, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...