SQLSERVER SQL语句：更新一列为行号问题

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

查询显示行号

-- 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 总结

以上是内存溢出为你收集整理的SQLSERVER SQL语句：更新一列为行号问题全部内容，希望文章能够帮你解决SQLSERVER SQL语句：更新一列为行号问题所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。