T-SQL 中的 while 循环简单运用

if exists(select * from sys.databases where name ='stuDB1')
	drop database stuDB1
go
create database stuDB1
go
use stuDB1
go
create table stuInfo12
(
	stuNo int identity,
	stuName nvarchar(16),
	sttuAge int,
	grade float,
	statuss int
)
insert into stuInfo12 values('夏冬',55,20,1)
insert into stuInfo12 values('马超',464,40,1)
insert into stuInfo12 values('张辽',554,60,1)
insert into stuInfo12 values('马岱',54,80,1)
insert into stuInfo12 values('徐晃',88,100,0)
insert into stuInfo12 values('曹仁',88,100,null)
--while循环
--可嵌套，break 跳出整个循环，continue跳出本次循环，开始下一次循环continue后的代码不在执行
--简单运用执行循环添加
declare  @num int
	set @num =1
--5时候跳出循环，但包含5
while(@num<5)
	begin
		set @num=@num+1
		insert into stuInfo12 values('曹操',88,@num,1)
	end
select * from stuInfo12
--为成绩不及格的学生每次加10分知道所有人都及格为止

declare @count int

while(1=1)
	begin
		select @count=count(*) from stuInfo12 where grade<60
		if(@count>0)
			update stuInfo12 set  grade =grade +10   where grade<60
		else
			break
	end
select * from stuInfo12

 

执行以上代码将显示一下结果