select '9' +replicate('0',len(max(itemid))-1-len(max(cast(substring(itemid,patindex('%[1-9]%',itemid),len(itemid))as int))+1))
+cast(max(cast(substring(itemid,patindex('%[1-9]%',itemid),len(itemid))as int))+1 as int) as itemid
from ItemsMaterialitemid 为 Int
+cast(max(cast(substring(itemid,patindex('%[1-9]%',itemid),len(itemid))as int))+1 as int) as itemid
from ItemsMaterialitemid 为 Int
patindex('%[1-9]%',itemid)
--> 改写为
patindex('%[1-9]%',cast(itemid as varchar(200))