-- 使用declare 声明变量
declare @i int
declare @sumPhone int
-- 使用 set 为变更赋值
set @i = 1set @sumPhone = 18621192
--循环插入数据
while(@i <= 10000)begin
insert into DSN_WeChatCustomer values('',@sumPhone,'')
set @sumPhone = @sumPhone+@i
set @i = @i +1
end