如此就可!
CREATE PROCEDURE [lekey] AS
declare @i int,@j int
set @i=1
set @j=1
while (@i<12)
begin
insert into computer_cost select top 9 depart_name , computer_name, computer_count, uom, computer_price, computer_money, dateadd(mm,@i,times), expense_no from computer_cost
set @i=@i+1
end
CREATE PROCEDURE [lekey] AS
declare @i int,@j int
set @i=1
set @j=1
while (@i<12)
begin
insert into computer_cost select top 9 depart_name , computer_name, computer_count, uom, computer_price, computer_money, dateadd(mm,@i,times), expense_no from computer_cost
set @i=@i+1
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货