Oracle: select LPAD(number_no,20,'0') from dual select LPAD(3,20,'0') from dual 效果:000000000000000000003 Mssql: select replicate('0',20)+ltrim(tt.number_no) from Tabletest as tt 效果:000000000000000000003 MySQL: select LPAD(number_no,20,'0') from dual 同时 在MySQL中 继续调用其他存储过程的方法: CALL get_water("Water",1,water_num); Oracle 的调用: get_water('Water'1,water_num); mssql:中的调用: exec get_water "Water",1,water_num output;