select max(cast(RoleCode(列名) as int))from xt_RoleInfo(表名) select max(cast(RoleCode as int))+1 from xt_RoleInfo