用存储过程在数据库中批量插入数据1w条

Create proc Sp_Test
As     --易漏
Begin
Declare @Count Int
set @Count =0
while (@count <10000)
Begin
Insert into dbo.Users
values ('will','123')
set @Count =@Count +1
End
End