sql update Row_Number 

1 With [TempTable] As (
2 Select [FieldID], Row_Number() Over(Order By [FieldID]) RowNumber From [Target]
3 )
4 Update [TempTable] Set [FieldID] = RowNumber

 

posted @ 2024-08-20 17:18  。活着。  阅读(23)  评论(0)    收藏  举报