请做表专家给做个图表
来源:百度知道 编辑:UC知道 时间:2024/05/16 11:53:54
邮箱:diqixingzuo@163.com
我不知道你的具体要求,我做了一个表,你看看如何:
以下是代码
---------------------------------------------------------------
create table sellplan(
months int primary key,
agent_sale int null,
agent int null,
salary int null,
phone_fee int null,
evection_fee int null,
serve_fee int null)
go
declare @i int
declare @j int
declare @k int
set @i=1
set @j=10000
set @k=10
while @i<=12
begin
insert into sellplan values(@i,@k*@j,@k,3000*@k,50*@k,1000*@k,100*@k)
set @i=@i+1
set @k=@k+2
end
go
alter table sellplan add agin int
go
update sellplan
set agin=(agent_sale-salary-phone_fee-evection_fee-serve_fee)
go
---------------------------------------------------------------
以下是运行结果:
--------------------------------------------
months agent_sale agent salary phone_fee evection_fee serve_fee agin
----------- -------