sqlserver新增多个用户信息

DECLARE @i INT = 4; -- 从test2开始
DECLARE @max INT = 99; -- 生成100个用户，所以最大值为2+100

WHILE @i < @max
BEGIN
    INSERT INTO [dbo].[Base_Users] (UserNo, UserName, UserType, Password, sex,IdCard,Mobile,Email,DepartmentId, Avatar, IsEnable, InitialPassword,IndividualResume,lastLoginTime)
    VALUES 
    ('test' + CAST(@i AS VARCHAR(3)), '测试' + CAST(@i AS VARCHAR(3)), 2, '123456', 1,'','','', '8','', 1, 0,'', GETDATE());

    SET @i = @i + 1;
END