我没找到,但我觉得可以这样写:
declare @x as int,@num as int
set @x=5
set @num=345
select replicate('0',@X-len(cast(@num as varchar(255))))+cast(@num as varchar(255))
其中@X为字符总长.
declare @x as int,@num as int
set @x=5
set @num=345
select replicate('0',@X-len(cast(@num as varchar(255))))+cast(@num as varchar(255))
其中@X为字符总长.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货