OPENJSON and CROSS APPLY

• by Marty

• measure twice, cut once.

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...

2020-06-24 (first published: 2020-06-09)

741 reads

OPENJSON and an Alias

• by Marty

• measure twice, cut once.

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

1 reads

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

• by Marty

• measure twice, cut once.

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...

2020-06-07

1 reads

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

• by Marty

• measure twice, cut once.

We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...

2020-06-07

1 reads

OPENJSON – using an explicit schema. The WITH clause.

• by Marty

• measure twice, cut once.

G’day, Previously, we have looked at using OPENJSON to gain knowledge about the JSON document that we have presented to the function. A bit like this Notice that we...

2020-06-05

3 reads

OPENJSON, explicit schema and data type

• by Marty

• measure twice, cut once.

Back in our last instalment, we looked at OPENJSON and how we can get data into a tabular format from a JSON document. Readers may have noticed that we...

2020-06-05

1 reads

T-SQL Sequences and the OVER() clause

• by Marty

• measure twice, cut once.

Using a SEQUENCE object - in unusual ways!

2020-06-04

1 reads

OPENJSON – using the default schema to collect new information

• by Marty

• measure twice, cut once.

We’ve looked at reading JSON from disk and also verifying that a string we have contains valid JSON data. But, naturally, we’d like to do more than that. Well,...

2020-05-27

JSON data and a T-SQL variable.

• by Marty

• measure twice, cut once.

G’day, You may have noticed when looking at FOR JSON AUTO or FOR JSON PATH that both clauses result in one single column that contains a JSON string. But,...

2020-05-23

JSON, SQL Server and Esacpe Characters of the non-printable kind

• by Marty

• measure twice, cut once.

G’day, We observed in a previous installment that JSON uses the backslash character “” as the escape character. However, what happens if we actually want a backslash in our...

2020-05-20