Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - "BEGIN ... END" - Statement Structures
(Continued from previous topic...)
How To Use "BEGIN ... END" Statement Structures?
"BEGIN ... END" statement structure is used to group multiple statements into a single statement block,
which can be used in other statement structures as a single statement.
For example, a statement block can be used in an "IF ... ELSE ..." statement structure as a single statement.
The tutorial exercise below shows you how to use "BEGIN ... END" statement structures
to place multiple statements into an "IF ... ELSE" statement structure:
DECLARE @site_name VARCHAR(40);
SET @site_name = 'SQA';
IF @site_name = 'DBA'
PRINT 'Dropping table: dba_links';
DROP TABLE dba_links;
ELSE IF @site_name = 'SQA'
PRINT 'Dropping table: sqa_links';
DROP TABLE sqa_links;
PRINT 'Unknown site name: '+@site_name;
Dropping table: sqa_links
(Continued on next topic...)
- How To Use "IF ... ELSE IF ... ELSE ..." Statement Structures?
- How To Use "BEGIN ... END" Statement Structures?
- How To Use WHILE Loops?
- How To Stop a Loop Early with BREAK Statements?
- How To Skip Remaining Statements in a Loop Block Using CONTINUE Statements?