I’ve recently been doing a lot of JSON stuff in T-SQL. I figured it would […]
Tag: T-SQL
SQL Server – Drop All Objects in Database via SqlPackage
The Quick Answer: Deploy an empty database project. If you have temporal tables, you’ll need […]
T-SQL – Collate Columns on Joins
This is an extension of my Cannot Resolve Collation Conflict post. However, in this post, […]
SSIS – Error: “metadata could not be determined because procedure uses temp table”
When you have a stored procedure that utilizes a temp table, SSIS may not be […]
T-SQL – Using Wildcards with LIKE
Ever need to find a value in a column where it’s LIKE something? T-SQL provides […]
T-SQL – Skip X Number of Rows
There may come a time when you need to skip a certain number of rows […]