SQL Server: TSQL Script to find Count the number of Occurrences of a String

In this post, I am sharing one TSQL script to find count the number of occurrences of a string in SQL Server.

This is a very basic demonstration, but sometimes it helps a lot to do this kind basic analysis using TSQL.

Sometimes, we find that column like Reasons or Remarks has some duplicate words or strings. As we are using this data for our report’s purpose, so it needs to find the total number of occurrences for that string.
Based on this count, we can perform further operations like: update, delete of that duplicate words.

Below is a small demonstration of this:

First, Create a table with sample data:

Script to find the occurrence of ‘demo’ word:

The Result:

SQL Server String Occurrence

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server: TSQL Script to find Count the number of Occurrences of a String"

Notify of
avatar
Sort by:   newest | oldest | most voted
bayu
Guest

Thank You Bro

wpDiscuz