CREATE TABLE T_test
(Name varchar(50)
)
INSERT T_test(Name) VALUES('张三')
INSERT T_test(Name) VALUES('李四')
INSERT T_test(Name) VALUES('王五')
select * from T_test
update tempTable set name =name + right('00000'+ CAST(rownum as NVARCHAR),5) from(
select name, ROW_NUMBER() over(order by name) rownum from T_test
) tempTable
select * from T_test
(Name varchar(50)
)
INSERT T_test(Name) VALUES('张三')
INSERT T_test(Name) VALUES('李四')
INSERT T_test(Name) VALUES('王五')
select * from T_test
update tempTable set name =name + right('00000'+ CAST(rownum as NVARCHAR),5) from(
select name, ROW_NUMBER() over(order by name) rownum from T_test
) tempTable
select * from T_test
update temptable set name =name + right('00000'+ CAST(rownum as NVARCHAR),5) from(
select name, ROW_NUMBER() over(order by name) rownum from T_test
) temptable
right 方法就是在左边补0的
drop table T_test