数据库表按序号补足6位

select RIGHT('000000'+RTRIM(LTRIM(ROW_NUMBER () over(order by createtime))),6) num, Id from table