sql server 批量插入及更新

插入

USE [RYAccountsDB]
GO
DECLARE @CountBegin INT
DECLARE @CountBeginx INT
DECLARE @CountEnd INT

 

SET @CountBegin = 258
SET @CountEnd = 5000 

SET @CountBeginx = 100369 

WHILE(@CountBegin <= @CountEnd)
BEGIN
SET IDENTITY_Insert GameIdentifier ON;
insert into dbo.GameIdentifier (UserID,GameID,IDLevel) values(@CountBegin,@CountBeginx,0);
SET IDENTITY_Insert GameIdentifier Off;

SET @CountBegin = @CountBegin + 1;
SET @CountBeginx = @CountBeginx + 1;
END

 

 

更新

USE [RYAccountsDB]
GO
UPDATE A SET A.GameID = B.GameID FROM dbo.AccountsInfo A INNER JOIN dbo.GameIdentifier AS B ON B.UserID = A.UserID WHERE A.IsAndroid = 1