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
No Data Now...
| ©2003-2008 Woody. Some Rights Reserved. Feed - Sitemap - Valid XHTML - Valid CSS - Creative Commons Powered by ABlog v3.2. Skin Reserved by Default | Processed in 0.031250 Seconds. 4 Queries | 浙ICP备07029590号 |