Skip to content

AasishKumarSharma/MSSQL_ParseNestedJSONIntoTable

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

MSSQL: Parse Any Nested JSON Into Tabular Form

MSSQL query to parse any nested JSON data into tabular form using MSSQL JSON parser.

  • Related to MSSQL JSON Parser Engine. MSSQL Version 2017+
  • Parses any complex or nested JSON string (JSON data) from a JSON log table for each header (nested level) into a proper tabular form (flat table with fixed format).
  • Then inserts them into respective table.
  • Condition:
    • Nesting Level: Upto 10 levels (can be increased).

About

MSSQL query to parse any nested JSON data into tabular form using MSSQL JSON parser.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages