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, 2989👍, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
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...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...