111,094
社区成员




--CHARINDEX
SELECT *
FROM #T
WHERE ParentID = 'P001'
AND 15 BETWEEN
CAST(SUBSTRING(DataRange, 0, CHARINDEX(':', DataRange)) AS INT)
AND
CAST(SUBSTRING(DataRange, CHARINDEX(':', DataRange) + 1, LEN(DataRange)) AS INT)
SELECT *
FROM #T
WHERE ParentID = 'P001'
AND 15 >= -- 界值处理
CAST(SUBSTRING(DataRange, 0, CHARINDEX(':', DataRange)) AS INT)
AND < -- 界值处理
CAST(SUBSTRING(DataRange, CHARINDEX(':', DataRange) + 1, LEN(DataRange)) AS INT)