SET IDENTITY_INSERT [UserRole] ON;SELECT ROW_NUMBER() OVER ( ORDER BY T1.ID ) i,T1.ID INTO #A FROM [GMSAccount].[dbo].[User] AS T1JOIN [GMSToolManage].[dbo].[Manager] AS T2ON T1.EmpID=T2.ID;DECLARE @count INT;SELECT @count=COUNT(1) FROM #A; DECLARE @tot INT;SELECT @tot=COUNT(1) FROM [GMSAccount].[dbo].[UserRole]; DECLARE @i INT=1;WHILE(@i<=@count)BEGIN INSERT INTO [GMSAccount].dbo.[UserRole](ID,UserID,RoleID) SELECT @i+@tot,ID,5 FROM #A WHERE i=@i; SET @i=@i+1; END;if OBJECT_ID(‘tempdb..#A‘) is not null drop table #A;SET IDENTITY_INSERT [UserRole] OFF;DBCC CHECKIDENT(UserRole)--修改标识列值