sql批量插入数据

  begin    declare @i int    declare @name nvarchar

    set @i = 2    while @i < 5000        begin            set @name = 'user' + convert(nvarchar, @i)            insert into EricSun_DB.dbo.Users([LoginName]                                          ,[Email]                                          ,[DomainGroup]                                          ,[Title]                                          ,[Manager]                                          ,[Department]                                          ,[IsActive]                                          ,[IsDeleted]                                          ,[SID]                                          ,[Flags]                                          ,[DisplayName])                         values(@name, 'email', 0, 'mvp', 'manager', 'deparment', 0, 0, 0, 0, 'display name')            set @i = @i + 1        end  end