SQLServer常用个技巧（一）：根据某字符截取后面的字符串，String转int
标签：span join and 结果 from image res serve info
SQLServer常用个技巧（一）：根据某字符截取后面的字符串，String转int
GOODS_CD AS goodsCd, 原字符串
reverse( GOODS_CD ) AS dCsdoog, 颠倒
LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) AS tluser, 按符号‘-’进行分割
reverse( LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) ) AS result, 将结果倒过来
CONVERT ( INT, reverse( LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) ) ) AS resultInt 将string转成int
FROM
PI_DSL_ORDER_GOODS og
JOIN PI_ST_ENTRY_GOODS eg ON eg.ID = og.GOODS_ID
AND eg.DATA_STATUS = ‘1‘
WHERE
1 = 1
AND og.DATA_STATUS = ‘1‘
AND og.ORDER_ID = ‘484eaa92bf5d43c1bb24625688ea7464‘