SQL Server 补位

select RIGHT(REPLICATE('0',3)+CAST(3 AS varchar(10)),3)
003
select RIGHT(REPLICATE('0',3)+CAST(12 AS varchar(10)),3)
012
select RIGHT(REPLICATE('0',3)+CAST(123 AS varchar(10)),3)
123
原文地址:https://www.cnblogs.com/xiaoruilin/p/13503725.html