Category: RegEx

SQL Server meta-development (with regular expressions and more)

Post author By Jen McCown
Post date October 13, 2021
Categories In Advanced, Applied SQL, Dev, Intermediate, Random helpfulness, RegEx, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL

Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. I could, of course, go through the entire list of queries manually, crafting CREATE PROC statements and so on. But what’s the fun in that? As much as possible, I like to use scripts on […]

Regular Expressions: tagging expressions

Post author By Jen McCown
Post date October 15, 2018
Categories In RegEx, sql server, sqlserverpedia-syndication, SSC, Tech and Learning

I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take a minute to define regular expressions, explain tagged expressions, and then show you how to use it in the same line. But first, XKCD: Regular Expressions defined “A regular expression, regex or regexp [is]… a sequence of characters that define a search pattern. Usually this pattern […]