SMC

OPENJSON and CROSS APPLY

June 10th, 2020

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that..

Read More

OPENJSON and an Alias

June 9th, 2020

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some..

Read More

OPENJSON : Getting to the data, and the PATH – PART I

June 8th, 2020

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL..

Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search