update TableName set ConsultantID=right(cast('1000000000'+CONVERT(int,ConsultantID) as varchar(10)),9)
转载于:https://www.cnblogs.com/monkeyfather/p/3867879.html
update TableName set ConsultantID=right(cast('1000000000'+CONVERT(int,ConsultantID) as varchar(10)),9)
转载于:https://www.cnblogs.com/monkeyfather/p/3867879.html