CREATE TABLE Table1
(A varchar(7),B varchar(20),C varchar(20));

INSERT INTO Table1 (A, B,C)
VALUES
('106091', '1071101001','Q'),
('106100', '1071101002','W'),
('106104', '1071101003','E'),
('107091', '1071101001','R'),
('107100', '1071101002','T'),
('107104', '1071101003','A'),
('107105', '1071101004','S'),
('107106', '1071101005','D'),
('107107', '1071101006','F'),
('107180', '1071101007','G');

INSERT INTO Table1 (A,B,C)
SELECT A,B,C
FROM Table1
FULL OUTER JOIN (SELECT TOP (299) 1 AS ROWNUM
FROM master..spt_values) AS P ON 1=1;

Demo

寫個自動程式讓它跑?
我們以前一天增加10G硬碟空間...

把自己目前的資枓再灌回給自己
而且是以成倍的方式在長大
執行10次就有1024筆了

  insert into [MyLab].[dbo].[myTable]
  select * from [MyLab].[dbo].[myTable]