Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. ...

sp_select and sp_select_get_rowcount A very hard to crack issue when debugging TSQL Stored procedures on SQL Server from the earliest versions all the way to SQL Server 2016 is the fact that you can ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses.

(SQL Server 2000)I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.I then have a correlated subquery that runs against the temp table.Now when ...