您可以使用replace将每次出现的时间延长1个字符，并计算添加的字符数:

You could use replace to make each occurrence 1 character longer, and count the number of added characters:

select  len(replace(txt, search, search + '#')) - len(txt) as Count
,       *
from    YourTable

SE Data的完整示例.