Count number of strings within a string

This function will return the number of occurrences of one string within another string. I was looking for something like this recently, and the only thing I could find was needlessly complicated. Don't forget, when calling a scalar function, you must qualify with username like this:Select dbo.StringCount('Hi There','e') This function may be a little too […]

2004-03-09

150 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

On Looking and Acting the Part

By Phil Factor

Comments posted to this topic are about the item On Looking and Acting the...

How to make group by Revision_ID and when repeated display last check date separ

By ahmed_elbarbary.2010

problem How to make group by Revision_ID and when repeated display last check date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers