求教大神
sqlserver吧
全部回复
仅看楼主
level 2
gcc魔图 楼主
纠结了一晚上了,求大神解答
2017年03月27日 13点03分 1
level 2
gcc魔图 楼主
上面看不清下面有
2017年03月27日 13点03分 2
level 11
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
菜鸟求交流~
2017年03月30日 01点03分 3
从declare到'元'都是存储过程里的内容 select * from salary 之前的部分都可以无视了~~
2017年03月30日 01点03分
1