，假设admin1code的数据类型为(n)varchar

assuming admin1code is of datatype (n)varchar

Update Country
set admin1code = right('00'+ admin1code, 2)

尝试:

UPDATE Country SET admin1code = '0' + admin1code WHERE LEN(admin1code) = 1 AND admin1code >= '0' and admin1code <='9'