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)
2,179 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,908 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,563 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,519 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)
920 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)
985 reads
Blogs
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
A Successful Blogger on Making the Switch
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
Login Timeouts
I was recently approached at work about a company that was seeing tons of...
Forums
Oracle: ORA-01843: not a valid month
Hi I have the following query which works fine in Oracle SQL Developer. When...
SQL Server internal variable with DML type
Can you advice how to retrieve the DML type a query is running? Does...
How to Convert Oracle SQL to T-SQL
Hello Community, I have been given a challenge of converting the following SQL code...
Ask SSC