-- MSSQL Format int to Varchar
-- 左补0
case when len(cast(@SEQ as varchar)) >= 7
then cast(@SEQ as varchar)
else replicate('0', 7-len(cast(@SEQ as varchar))) + cast(@SEQ as varchar)
end
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12476590/viewspace-495640/,如需转载,请注明出处,否则将追究法律责任。