I have to count the number of instances of each word in the Comments column throughout the table using SQL Server. Eg:
1 I like working on SQL
2 I enjoy sleeping and like watching TV
So the output should be :
Could someone please suggest if there is a way to get this count using MS SQL?