请教一句update语句？
create table test
(

name varchar(20),
type varchar(20)
)
insert into test select 'a1 ', '半挂车 '
insert into test select 'a2 ', '半挂车 '
insert into test select 'a3 ', '半挂车 '
insert into test select 'a4 ', '半挂车 '
insert into test select 'a5 ', '半挂车 '
insert into test select 'a6 ', '半挂车 '

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

name type

1 半挂车
2 半挂车
3 半挂车
4 半挂车
5 半挂车
6 半挂车
*/
drop table test

[解决办法]
update test set [name]=right([name],len([name])-1)
[解决办法]
create table test
(

name varchar(20),
type varchar(20)
)
insert into test select 'a1 ', '半挂车 '
insert into test select 'a2 ', '半挂车 '
insert into test select 'a3 ', '半挂车 '
insert into test select 'a4 ', '半挂车 '
insert into test select 'a5 ', '半挂车 '
insert into test select 'a6 ', '半挂车 '

Update A Set name = (Select Count(*) From test Where name <= A.name) From test A
select * from test