流程控制语句（Process control statement）.docVIP

流程控制语句（Process control statement） T-SQL- process control statement (Reprint) Process control statement Process control statements are the commands used to control program execution and process branches. In SQL Server 2000, the breeding control statement is used to control SQL statements, statement blocks, or stored procedure execution processes. (1). Begin end statement The begin end statement can combine multiple Transact - SQL statements into a block of statements and treat them as a unit of processing. In conditional statement and loop control flow statements, you need to use the beginend statement when you want to execute two or more statements when certain conditions are met: Begin {sql_statement statement_block} | End Cases: Use Taihang Go Declare @message varchar (200) If exists (select * from employee data sheet) Wheres Department = work room Begin Set @message = the following people work in the office Print @message Select employee name, from employee data sheet Wheres Department = office End Else Begin Set @message = no one in the office Print @message End Go (2). If else statement The if else statement is a conditional judgment statement in which the else clause is available first, and the simplest if statement does not have the else clause section. The if else statement is used to determine when a condition is set up and a program is executed. When the condition is not valid, another program is executed. SQL Server allows nested use of ifelse statements, and there is no limit to the number of nested tiers. Syntax: If boolean_expression {sql_statement statement_block} | [else {sql_statement|statement_block}] (3). If exists 1 the Boolean expression after.If may contain the select statement, and if the select statement is a value, it can be used to compare with another value to get a Boolean expression. 2 if the select statement returns more than one value, use if exists. The syntax is as follows: If exists (select statement) {sql_statement statement_bloc