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
SqlServer 查询字符的出现次数
最新推荐文章于 2023-09-08 09:43:10 发布
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