if-where

while循环

WHILE(条件表达式)
BEGIN —相当于C#里的{
语句
……
BREAK
END —相当于C#里的}

—如果不及格的人超过半数(考试题出难了)，则给每个人增加分
select from Score
declare @conut int,@failcount int,@i int=0 —定义变量
select @conut =COUNT() from Score —统计总人数
select @failcount =COUNT() from Score where english<100 --统计未及格的人数
while (@failcount>@conut/2)
begin
update Score set english=english+1
select @failcount=COUNT() from Score where english<100
set @i=@i+1
end
select @i
update Score set english=100 where english >100