create table table1(col varchar(50))
--drop table table1
go
---插入数据
insert into table1 values('1' )
insert into table1 values('2' )
insert into table1 values('9' )
insert into table1 values('11' )
insert into table1 values('123' )
insert into table1 values('259' )select right(cast (col+10000 as varchar(5)),4) as aa from table1
--drop table table1
go
---插入数据
insert into table1 values('1' )
insert into table1 values('2' )
insert into table1 values('9' )
insert into table1 values('11' )
insert into table1 values('123' )
insert into table1 values('259' )select right(cast (col+10000 as varchar(5)),4) as aa from table1
create table table1(col varchar(50))
--drop table table1
go
---插入数据
insert into table1 values('1' )
insert into table1 values('2' )
insert into table1 values('9' )
insert into table1 values('11' )
insert into table1 values('123' )
insert into table1 values('259' )select left('0000',4-len(col))+col as aa from table1
set 列名=right(('0000'+列名),4)
create table kk2(id int identity,name varchar(10))
insert into kk2
select 'a1' union all
select 'a2' union all
select '1' union all
select '2' union all
select '3'
select * from kk2update kk2
set name=right(('0000'+name),4)
select * from kk2
你的方法正确而且简单,怎么给你给分啊?