SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Alan Burstein

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

DigitsOnlyEE and AlphaNumericOnly

A nasty fast way to remove non-numeric and non-alphanumeric characters from a string  Read more...
By Alan Burstein 2017/04/27 | Source: SQLServerCentral.com | Category: string function
Rating: |  Discuss |   Briefcase | 807 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  Read more...
By Alan Burstein 2016/06/22 | Source: SQLServerCentral.com | Category: set-based
Rating: |  Discuss |   Briefcase | 923 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.  Read more...
By Alan Burstein 2016/06/01 | Source: SQLServerCentral.com | Category: string function
Rating: |  Discuss |   Briefcase | 819 reads

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.  Read more...
By Alan Burstein 2016/04/27 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 885 reads

GetNumsAB

A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.  Read more...
By Alan Burstein 2016/04/19 | Source: SQLServerCentral.com | Category: set based
Rating: |  Discuss |   Briefcase | 743 reads

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2017/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,715 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,142 reads
   Items 1 to 7 of 7