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