34,571
社区成员
发帖
与我相关
我的任务
分享
if exists(select * from sys.objects where name='usp_upGrade')
drop proc usp_upGrade
create procedure usp_upGrade
as
declare @count int,@failcount int
select @count=COUNT(*) from Score
select @failcount=COUNT(*) from Score where english<60
while (@count/2 <@failcount)
begin
update Score set english=english+2
select @count=count(*) from Score where english<60
end
update Score set english=100 where english>100
if exists(select * from sys.objects where name='usp_upGrade')
drop proc usp_upGrade
go
create procedure usp_upGrade
as
declare @count int,@failcount int
select @count=COUNT(*) from Score
select @failcount=COUNT(*) from Score where english<60
while (@count/2 <@failcount)
begin
update Score set english=english+2
select @count=count(*) from Score where english<60
end
update Score set english=100 where english>100
if exists(select * from sys.objects where name='usp_upGrade')
drop proc usp_upGrade
go
create procedure usp_upGrade
as
declare @count int,@failcount int
select @count=COUNT(*) from Score
select @failcount=COUNT(*) from Score where english<60
while (@count/2 <@failcount)
begin
update Score set english=english+2
select @count=count(*) from Score where english<60
end
update Score set english=100 where english>100
go