drop table a
create table a
(
ca varchar(10) null,
cb varchar(10) null,
cc int null
)
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
declare @i int
set @i=1
update a set cc=@i,@i=@i+1
create table a
(
ca varchar(10) null,
cb varchar(10) null,
cc int null
)
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
insert into a(ca,cb) values('aa','bb')
declare @i int
set @i=1
update a set cc=@i,@i=@i+1
select * from a
结果: