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
SQL Server 补位
原文：https://www.cnblogs.com/xiaoruilin/p/13503725.html
