sql 循环转移备份数据

 

--创建表结构

select top 1 * into ATable_20190710 from ATable

--转移表数据

insert into ATable_20190710 select top 10 * from ATable

--删除

DELETE TOP (1) from WAppPageStatistics

DECLARE @iloop INT

SET @iloop = 1

WHILE @iloop <=10
BEGIN

PRINT CONVERT(VARCHAR,@iloop)+'a'

SET @iloop =@iloop+1

END