DECLARE @NUM CHAR(3)='7 'SELECT RIGHT('0000000'+CONVERT(VARCHAR(50),1+ RTRIM(@NUM)),7) 转载于:https://www.cnblogs.com/bu-dong/p/11171245.html