data-marty

Interests: Playing Guitar,Music Theory

Website: http://martincatherall.com/

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

by data-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

26 reads

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

by data-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

7 reads

OPENJSON – using an explicit schema. The WITH clause.

by data-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

131 reads

OPENJSON, explicit schema and data type

by data-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

165 reads

T-SQL Sequences and the OVER() clause

by data-marty

measure twice, cut once.

Using a SEQUENCE object - in unusual ways!

2020-06-04

78 reads

OPENJSON – using the default schema to collect new information

by data-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

125 reads

JSON data and a T-SQL variable.

by data-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

2,096 reads

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

by data-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

154 reads

Data Privacy – Playing your part

by data-marty

measure twice, cut once.

Tuesday 28th January 2020 was “Data Privacy Day 2020” Some may refer to this as Data Protection Day, but it is really just a day to draw attention to...

2020-03-10 (first published: 2020-02-03)

197 reads

A trusty old friend – The BCP utility

by data-marty

measure twice, cut once.

One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...

2020-03-08

228 reads

All authors

data-marty

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

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

OPENJSON – using an explicit schema. The WITH clause.

OPENJSON, explicit schema and data type

T-SQL Sequences and the OVER() clause

OPENJSON – using the default schema to collect new information

JSON data and a T-SQL variable.

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

Data Privacy – Playing your part

A trusty old friend – The BCP utility

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

Forums

Alamat kontak resmi BCA KCP Tebet Telp:0818751777

Stan Phone Number Australia +61-1800868603 Quick Help Guide

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

Question of the Day

Detecting Characters