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,540 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,820 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,233 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,306 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)
885 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)
942 reads
GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2016-04-19 (first published: 2016-03-23)
788 reads
Blogs
Renewed as a Friend of Red Gate
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another...
Forums
SSMA 8.6 Unable to find functions in extended stored procedures
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Running generic query for table information
Hi, I want to run the below query to get information about the tables...
Instance level trigger to store login information (who created what)
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC