select top 1 cast(SUBSTRING(MultiPackageOther, charindex(’-’,MultiPackageOther)+1, DATALENGTH(MultiPackageOther)) as int) as maxpage from T_OrderPackages where OrderId=’’ order by maxpage desc
杂 查询分割列select top 1 cast(SUBSTRING(MultiPackageOther, charindex(’-’,MultiPackageOther)+1, DATALENGTH(MultiPackageOther)) as int) as maxpage from T_OrderPackageswhere OrderId=’’ order by maxpage des...