SET NOCOUNT ON;
USE tempdb;
GO
CREATE TABLE dbo.Test1 (
  Id int NOT NULL IDENTITY PRIMARY KEY,
  c1 int DEFAULT 1,
  c2 int DEFAULT 2,
  c3 int DEFAULT 3,
  c4 int DEFAULT 4,
  c5 int DEFAULT 5,
  c6 int DEFAULT 6,
  c7 int DEFAULT 7,
  c8 int DEFAULT 8,
  c9 int DEFAULT 9,
  c10 int DEFAULT 10
  );
CREATE TABLE dbo.Test2 (
  Id int NOT NULL IDENTITY PRIMARY KEY,
  c1 int DEFAULT 1,
  c2 int DEFAULT 2,
  c3 int DEFAULT 3,
  c4 int DEFAULT 4,
  c5 int DEFAULT 5,
  c6 int DEFAULT 6,
  c7 int DEFAULT 7,
  c8 int DEFAULT 8,
  c9 int DEFAULT 9,
  c10 int DEFAULT 10
  );
GO
PRINT 'Popolamento iniziale';
DECLARE @i int;
SET @i = 1;
WHILE @i <= 100 BEGIN;
  INSERT INTO dbo.Test1 DEFAULT VALUES;
  SET @i = @i + 1;
END;
SELECT * FROM dbo.Test1;
GO
PRINT 'Trasferimento';
INSERT INTO dbo.Test2 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10 ) 
  SELECT c1, c2, c3, c4, c5, c6, c7, c8, c9, c10 
    FROM dbo.Test1
    ORDER BY Id;

SELECT * FROM dbo.Test2;
GO
DROP TABLE dbo.Test1, dbo.Test2;