Month: June 2019

Querying SQL Server with something LIKE a regular expression

Querying SQL Server with something LIKE a regular expression

Most of us are familiar with the LIKE command in SQL Server (and other DBMS environments), but few venture beyond simple text matching and the ‘%’ wildcard. It’s ability to use some regular expression (a.k.a. regex or regexp) syntax is a surprise to many. For this article, I’m assuming that readers have already used the…

Read More Read More

Object Catalog Views: Table Metadata

Object Catalog Views: Table Metadata

It’s handy to programmatically get metadata on tables (column names and datatypes), either to review implementation, or as part of a process automating code creation.