select right('00000000000'+convert(varchar(5),123),5)
select right('00000000000'+cast(123 as varchar(6)),6)
本文共 173 字，大约阅读时间需要 1 分钟。
select right('00000000000'+convert(varchar(5),123),5)
select right('00000000000'+cast(123 as varchar(6)),6)
转载于:https://www.cnblogs.com/xcj26/archive/2012/02/08/2342713.html