SQL SERVER 查找某个字符在字符串中出现的次数
DECLARE @people NVARCHAR(50); SELECT @people = '钟兴许-李凯鹏-刘建锋'; SELECT LEN(@people) - LEN(REPLACE(@people, '-', ''))
DECLARE @people NVARCHAR(50); SELECT @people = '钟兴许-李凯鹏-刘建锋'; SELECT LEN(@people) - LEN(REPLACE(@people, '-', ''))