循环插入数据

declare @sj varchar(4)
set @sj = cast(year(getdate()) as varchar)
delete from rpt_重点公益林资源结构汇总表 where sj = @sj
declare @hc int
set @hc = 1
while @hc < 41
begin
 insert into rpt_重点公益林资源结构汇总表(行次,sj)
 values
 (@hc,@sj)
 set @hc=@hc + 1
end

Permalink | Comments (0) | Hits: 1408 | Time: 10:45:33
一个分页的存储过程
SQL游标快速上手
All Comments

 No Data Now...

Post Your Comment
^ ^

Top