Oracle: select LPAD(number_no,20,'') from dual select LPAD(3,20,'') from dual 效果:000000000000000000003 Mssql: select replicate('',20)+ltrim(tt.number_no) from Tabletest as tt 效果:000000000000000000003 MySQL: select LPAD(number_no,20,'') 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;