查询显示行号
-- select row_number() over (order by createdate) as rowNum,t.* from Base_DataDictionaryDetail t;
更新一列为行号
update Base_DataDictionaryDetail
set DataDictionaryDetailid=t1.rowId
from
(
--select * from
--(
select DataDictionaryDetailid,row_number() over (order by DataDictionaryDetailid) as rowId
from Base_DataDictionaryDetail
) as t1
where t1.DataDictionaryDetailid=Base_DataDictionaryDetail.DataDictionaryDetailid
--) as t