摘要: SELECT ROW_NUMBER() OVER ( ORDER BY Location ) i,* INTO #A FROM [GMSToolManage].dbo.[Location]; DECLARE @count INT; SELECT @count=COUNT(1) FROM #A; DE 阅读全文
posted @ 2020-05-23 16:55 aq_seabiscuit 阅读(389) 评论(0) 推荐(0) 编辑
摘要: SET IDENTITY_INSERT [UserRole] ON; SELECT ROW_NUMBER() OVER ( ORDER BY T1.ID ) i,T1.ID INTO #A FROM [GMSAccount].[dbo].[User] AS T1 JOIN [GMSToolManag 阅读全文
posted @ 2020-05-23 15:41 aq_seabiscuit 阅读(287) 评论(0) 推荐(0) 编辑