use RYAccountsDB
create table #t(username nvarchar(50)) 

bulk insert #t from 'C:\Users\Administrator\Desktop\10000ID.txt' 
with 
( 
rowterminator='\n' 
) 
SELECT id=identity(int,1,1), t.username INTO #regtemp11 FROM #t t ORDER BY id DESC 


declare @i int,@Count int ,@BeginID int 
set @i=1 
set @BeginID=2    --ʼID
select @count=count(*) from #regtemp11 
set @count=@count+@i
while( @i<=@count ) 
BEGIN 
update AccountsInfo set dbo.AccountsInfo.Accounts=t.username, dbo.AccountsInfo.NickName=t.username, dbo.AccountsInfo.RegAccounts=t.username 
from AccountsInfo,#regtemp11 t
WHERE UserID IN(SELECT TOP (@i) UserID FROM dbo.AccountsInfo where UserID>=@BeginID) 
AND AccountsInfo.UserID NOT IN(SELECT TOP (@i-1) ISNULL(UserID,0) FROM dbo.AccountsInfo where UserID>=@BeginID) 
AND AccountsInfo.IsAndroid=1 
AND t.id=@i 
set @i=@i+1 
END 
DROP TABLE #t 
DROP TABLE #regtemp11