SqlServer 查询字符的出现次数

 

 

SELECT len('001_003_005_sadfasd')-len(REPLACE('001_003_005_sadfasd','_',''))

SELECT (len('001@@003@@005@@sadfasd')-len(REPLACE('001@@003@@005@@sadfasd','@@','')))/2