SqlServer使用Declare实现批量插入 declare @a int; set @a = 999999; DECLARE @i int; set @i = 0; WHILE @i <= 10 BEGIN set @a = @a + 1; set @i += 1; INSERT INTO [PARAM]([SYS_PARAM_ID], [SYS_ID]) VALUES (@a, '800'); END