给你实例:id为时间字段
create proc insertnewdata
as
begin
DECLARE @name char(10),@gongzi int,@times char(10),@id datetime,@dk bit DECLARE my_cursor CURSOR FOR
select * from table1
where left(id,9)=left(convert(getdate()-1, varchar(10)),9)
open my_cursor
FETCH NEXT FROM my_cursor into @name,@gongzi,@times,@id,@dk
WHILE @@FETCH_STATUS = 0
BEGIN
print('JDHFld')
insert into table1(name,gongzi,times,id,dk)values(@name,@gongzi,@times,@id+1,@dk)
FETCH NEXT FROM my_cursor into @name,@gongzi,@times,@id,@dk
END
CLOSE my_cursor
DEALLOCATE my_cursor
end
go
create proc insertnewdata
as
begin
DECLARE @name char(10),@gongzi int,@times char(10),@id datetime,@dk bit DECLARE my_cursor CURSOR FOR
select * from table1
where left(id,9)=left(convert(getdate()-1, varchar(10)),9)
open my_cursor
FETCH NEXT FROM my_cursor into @name,@gongzi,@times,@id,@dk
WHILE @@FETCH_STATUS = 0
BEGIN
print('JDHFld')
insert into table1(name,gongzi,times,id,dk)values(@name,@gongzi,@times,@id+1,@dk)
FETCH NEXT FROM my_cursor into @name,@gongzi,@times,@id,@dk
END
CLOSE my_cursor
DEALLOCATE my_cursor
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货