怎么从SELECT出来的数据中将数据一行一行的写入另一张表,最主要的是每写一行需要间隔一段时间
用SQL语句有办法吗?
------解决方案--------------------
- SQL code
declare @col varchar(19)declare cur cursor for select * from taopen curfetch cur into @colwhile @@fatch_satus = 0begin insert into othertb select @col waitfor delay '00:05' fetch cur into @colendclose curdeallocate cur