DECLARE @str VARCHAR(500)
SET @str = '0010000000000000,1000001000000000,1000000000000000,0000000000000010'
SELECT len(@str)-len(replace(@str, '1', ''))
--原理
替换为''后,计算就减少的字符
--如果是字符串,那就得/字符串的长度
DECLARE @str VARCHAR(500)
SET @str = '0010000000000000,1000001000000000,1000000000000000,0000000000000010'
SELECT (len(@str)-len(replace(@str, '01', '')))/len('01')