循环插入多条数据

declare @i int
set @i = 1
while @i < 100000
   begin

INSERT INTO [User] (AppId,UserId,UserName ,PassWord) VALUES (newid(),newid(),'11' ,'11')
   set @i = @i + 1
   end