SQL 如何跟新 为空的列

来源：百度知道 编辑：UC知道 时间：2024/06/23 02:12:00
update d set submissionid=dd from
(select submissionid , row_number() over(order by submissionid) as 'dd' from DOPWebForm ) as d 我的答案是这样！！

update d set submissionid=dd where submissionid is null

--SQL05以上版本这样用
;with d
as
(select submissionid , row_number() over(order by submissionid) as 'dd' from DOPWebForm )
update d
set submissionid=dd

--更新为null列时
;with d
as
(select submissionid , row_number() over(order by submissionid) as 'dd' from DOPWebForm )
update d
set submissionid=dd
where submissionid is null