sql 循环插入某一条数据

declare @i int
set @i=1
while @i<(10000)
begin

INSERT INTO [Table]( [IDi] ,[IDo] ,[Synci] )

( SELECT top 1 [IDi] ,@i ,[Synci] FROM [Table] )


set @i=@i+1

end

原文地址:https://www.cnblogs.com/ahuo/p/3635581.html