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
284 reads
When you want to compare two strings that may have case differences on a case-insensitive server, this script will quickly and easily do the compare for you. It returns 0 if strings are equal, 1 if not. Feel free to modify/reuse in your code.
2003-02-11
186 reads
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
By Steve Jones
I’m not looking for a job, but I ran across an article about using...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Hi All, Is there a way i can create package for an individual...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers