select right(replicate('0',10)+ltrim('123'),10) 结果:0000000123 转载于:https://www.cnblogs.com/diandianxinghen/p/3523788.html