create table salary(
tid int primary key identity,
employeeid varchar(20),
salary money,
)
insert into salary values('cxy001',1500)
insert into salary values('cxy002',1500)
insert into salary values('cxy003',1800)
insert into salary values('cxy004',1500)
insert into salary values('cxy005',1600)
insert into salary values('cxy006',1900)
insert into salary values('cxy007',1700)
insert into salary values('cxy008',5000)
insert into salary values('cxy009',1800)
insert into salary values('cxy010',1600)
truncate table salary
select * from salary
create procedure jiaxin
as
declare
@lower real,
@all real,
@percent real,
@times int
select @lower=count(tid) from salary where salary<2000
set @all=(select count(tid) from salary)
set @percent=@lower/@all
set @times=0
while(@percent>0.5)
begin
update salary set salary=salary+100
select @lower=count(tid) from salary where salary<2000
set @all=(select count(tid) from salary)
set @percent=@lower/@all
set @times=@times+1
end
print '加了'+Convert(varchar(20),@times)+'次'
print '共'+Convert(varchar(20),@all*100*@times)+'元'
exec jiaxin
菜鸟求交流~