[MS SQL]不足左補0

select RIGHT('0000000000' + CAST(123 as VARCHAR),10) ;

select REPLICATE('0', (10-LEN('123')))+'123';

select RIGHT(REPLICATE('0',10) + CAST(123 as VARCHAR),10);

PS. Oracle 用 LPAD/RPAD即可完成