uodate语句
create table test
(

pk_id varchar(20)

)
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '

--Update A Set pk_id = (Select Count(*) From test Where pk_id <= A.pk_id) From test A

select * from test
/*
写一句update语句,把pk_id列更新为 '1 ', '2 ', '3 '.....依次递增

name

1
2
3
4
5
6
*/
drop table test

[解决办法]
create table test
(

pk_id varchar(20)

)
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '
insert into test select '290 '

Declare @I Int
Select @I = 0
Update test Set pk_id = @I , @I = @I + 1

select * from test
[解决办法]
declare @ID int
SET @id = 0
UPDATE test SET
@id = @id + 1,
pk_id = @id
select * from test