sqlserver左侧填充0

DECLARE @NUM INT=7
WHILE (@NUM <=14)
BEGIN
    SELECT RIGHT('0000000'+CONVERT(VARCHAR(50),1+@NUM),7)
    SET @NUM+=1
END

参考：https://www.pianshen.com/article/2036638724/