Select @FNumber_int=isnull(max(isnull(cast (CASE WHEN charindex('-',FShortNumber)>1 then substring(FShortNumber,1,charindex('-',FShortNumber)-1)
else FShortNumber end as int) ,0)),0)+1
from t_Item
where FItemClassID=4 and FNumber like ('99'+'.%')
sqlserver select case then else end
于 2022-11-29 17:16:04 首次发布