数据库之流程控制语句

一、if  else 语句

declare @avg floatselect @avg = avg(english) from scoreprint '平均分数' + convert(varchar(20),@avg)if(@avg > 60)beginprint '前三名'select top 3 sName,english from student inner join score on student.sId=score.studentId order by english descendelsebeginprint '后三名'select top 3 sName,english from student inner join score on student.sId=score.studentId order by english ascend

其中，begin和end相当于“{}”大括号

二、while语句

declare @i int set @i=1while (@i<1000000)begin set @i=@i+1print @iend