select right('00000000000'+convert(varchar(5),123),5)
select right('00000000000'+cast(123 as varchar(6)),6)
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