怎么一次性修改多纪录

[ak30000]

我需要把某个空字段依次写入10001,10002,10003....升续的数字。
如何一次性完成？最好有实例

[vivianfdlpw]

select identity(int,10000,1) [tmp],* into # from table1
update table1 set [空列]=A.tmp from table1 join # A on A.[主键]=table1.[主键]
drop table #

[vivianfdlpw]

--创建测试环境
set nocount on
go
create table A
(
ID int primary key,
name varchar(20)
)
insert A(ID,name) select 1,null union all select 2,null union all select 3,null

--更新以前
select * from A

select identity(int,10000,1) [tmp],* into # from A
update A set [name]=B.tmp from A join # B on B.[ID]=A.[ID]
drop table #

--更新以后
select * from A

--删除测试环境
drop table A

--结果
/*
ID name
----------- --------------------
1 NULL
2 NULL
3 NULL

ID name
----------- --------------------
1 10000
2 10001
3 10002
*/