34,837
社区成员




declare @tb table (id varchar(10))
insert into @tb select '0001'
insert into @tb select '002'
insert into @tb select '03'
update @tb set id=REPLICATE('0',8-len(id))+id
select * from @tb
declare @tb table (id varchar(10))
insert into @tb select '0001'
insert into @tb select '0002'
insert into @tb select '0003'
update @tb set id=REPLICATE('0',8-len(id))+id
select * from @tb
update table
set 编号 = '000'+编号