update tablename set colname=replicate(0,'+cast(@strlength-len(colname) as varchar)+')+colname 转载于:https://www.cnblogs.com/lxydmq/archive/2008/06/10/1216836.html