if exists (select * from sysobjects where name='avg_wage')
drop procedure avg_wage
GO
create procedure avg_wage
@PWage int,
@AWage int,
@total int
as
while (1=1)
begin
if ((select avg(wage) from ProWage)<=@PWage)
update ProWage set @total=@total+@AWage,Wage=Wage+@AWage
else
break
end
print'一共加薪:'+convert(varchar,@total)+'元'
print'加薪后的程序员工资列表:'这里的as
while (1=1)
begin
else
break
是什么意思
drop procedure avg_wage
GO
create procedure avg_wage
@PWage int,
@AWage int,
@total int
as
while (1=1)
begin
if ((select avg(wage) from ProWage)<=@PWage)
update ProWage set @total=@total+@AWage,Wage=Wage+@AWage
else
break
end
print'一共加薪:'+convert(varchar,@total)+'元'
print'加薪后的程序员工资列表:'这里的as
while (1=1)
begin
else
break
是什么意思
update ProWage set @total=@total+@AWage,Wage=Wage+@AWage --更新Wage++@AWage ,@total+@AWage
循環直到平均wage大於@PWage時退出
break 跳出循环begin
if ((select avg(wage) from ProWage)<=@PWage)
update ProWage set @total=@total+@AWage,Wage=Wage+@AWage
else
break
end当不满足((select avg(wage) from ProWage)<=@PWage)条件时,执行break,跳出循环