SQLSERVER SQL语句：更新一列为行号问题
发布时间：2020-12-12 13:26:17 所属栏目：MsSql教程 来源：网络整理
导读：查询显示行号 -- 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 DataDi
|
查询显示行号 -- 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（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |