日期:2014-05-18 浏览次数:20587 次
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