日期:2014-05-18 浏览次数:20709 次
declare @col varchar(19)
declare cur cursor for select * from ta
open cur
fetch cur into @col
while @@fatch_satus = 0
begin
insert into othertb select @col
waitfor delay '00:05'
fetch cur into @col
end
close cur
deallocate cur