declare @t table
(
id int identity(1,1),
col varchar(10)
)
insert into @t (col)
select 'a'
union
select 'b'
union
select 'c'
select * from @t
select REPLICATE('0',4-len(id))+cast(id as varchar),col from @t
左填充
最新推荐文章于 2021-06-15 13:29:45 发布