摘要:sql 內 迴圈新增法
DECLARE @j int
SET @j = 12 WHILE (@j <= 99)
BEGIN
INSERT
INTO B1_2(欄位名)
VALUES (37, '1010524001', '0' + cast(@j AS char(2)),要加入欄位值 )
SET @j = @j + 1
END