question

David 2 1 avatar image
David 2 1 asked

How to Use TSQL to Query JSON String into its Component Parts?

Hi there,

I have 3 tables (JsonPage, JsonSection, JsonControl) into which I would like to split and store JSON strings relationally. Using tsql how do I query the JSON string to split it into its page, section, and control parts?

TIA

querytsqljson
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jon Crawford avatar image
Jon Crawford answered

check this out https://www.mssqltips.com/sqlservertip/5374/transforming-json-data-to-relational-data-in-sql-server-2016/

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.