DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,952 reads
Michael Colling
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
1,856 reads
New T-SQL Fixed Width "Splitter"
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
1,467 reads
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
3,425 reads
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
905 reads
Calculate Age (in years)
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
970 reads
Blogs
Logging Messages with Raiserror – #SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Daily Coping 8 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Webinar – Building a Proper SQL Server Database Security Model
By Brian Kelley
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...
Forums
SSRS report download fails
Hi. I am trying to download a report from SSRS 2019 in word format...
Many executionplans for one query, why?
I've yet to find an answer for this. I've found a few queries that...
Ask SSC