sql批量加数据

DECLARE @Start INT
DECLARE @End INT


DECLARE @GameID INT
DECLARE @Accounts NVARCHAR(31)


SET @Start=2201
SET @End=4000


WHILE @Start<=@End
BEGIN

SET @Accounts='Android'+cast(@Start as varchar(8))
-- 注册用户
INSERT AccountsInfo (Accounts,RegAccounts,LogonPass,InsurePass,SpreaderID,Gender,FaceID,MachineSerial,GameLogonTimes,RegisterIP,LastLogonIP,RegisterType,RegDeviceType,LogonDeviceType)
VALUES (@Accounts,@Accounts,'f6d6e14dcf754636ff2ae6da97a7fec9','f6d6e14dcf754636ff2ae6da97a7fec9',1,1,1,'',1,'127.0.0.1','127.0.0.1',1,3,3)


-- 分配标识
SELECT @GameID=GameID FROM GameIdentifier(NOLOCK) WHERE UserID=@Start
IF @GameID IS NULL 
BEGIN
SET @GameID=0
END
ELSE UPDATE AccountsInfo SET GameID=@GameID WHERE UserID=@Start




SET @Start=@Start+1
END