declare @idx int set @idx = 1 while(1=1) begin if @idx > 1000000 break; insert into test(a,b,d)values(@idx, 'a', 'bbbb'); set @idx = @idx + 1 end
[ms-sql] mssql while 예제 데이터 꼿어넣기
2010. 11. 17. 15:20
declare @idx int set @idx = 1 while(1=1) begin if @idx > 1000000 break; insert into test(a,b,d)values(@idx, 'a', 'bbbb'); set @idx = @idx + 1 end