Update T Set T.Id=T.rn From (
Select ROW_NUMBER() over(order by TableName.ColumnName) as rn
From TableName
) T
给堆文件加流水号(MSSQL)
最新推荐文章于 2021-02-11 07:47:18 发布
Update T Set T.Id=T.rn From (
Select ROW_NUMBER() over(order by TableName.ColumnName) as rn
From TableName
) T