Parse JSON in TSQL

by

I seem to have a huge masochistic streak in that I’ve written a JSON parser. It converts a JSON document into a SQL Adjacency list table, which is easy to use to update your data tables. Actually, I’ve done worse, in that I’ve done code to do the reverse process, which is to go from a hierarchy table to a JSON string

The article and code is here: Consuming Json strings in SQL server.

Select * from parseJSON('{
  "Person":
  {
     "firstName": "John",
     "lastName": "Smith",
     "age": 25,
     "Address":
     {
        "streetAddress":"21 2nd Street",
        "city":"New York",
        "state":"NY",
        "postalCode":"10021"
     },
     "PhoneNumbers":
     {
        "home":"212 555-1234",
        "fax":"646 555-4567"
     }
  }
}
')

To get:

enter image description here

More Related Contents:

  1. Comma separated results in SQL
  2. T-SQL stored procedure that accepts multiple Id values
  3. Understanding PIVOT function in T-SQL
  4. Calculate running total / running balance
  5. How do I escape a percentage sign in T-SQL?
  6. Using RegEx in SQL Server
  7. Get size of all tables in database
  8. Fuzzy matching using T-SQL
  9. List of all index & index columns in SQL Server DB
  10. Why use a READ UNCOMMITTED isolation level?
  11. Replace duplicate spaces with a single space in T-SQL
  12. How much size “Null” value takes in SQL Server
  13. SQL Server: Isolation level leaks across pooled connections
  14. How do I use the CONCAT function in SQL Server 2008 R2?
  15. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  16. How do I exclude Weekend days in a SQL Server query?
  17. EXEC sp_executesql with multiple parameters
  18. Preserving ORDER BY in SELECT INTO
  19. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  20. Can you call a webservice from TSQL code?
  21. How to add custom attributes to SQL connection string?
  22. Multiple Column Pivot in T-SQL
  23. Joining multiple tables returns NULL value
  24. Which join syntax is better?
  25. Compute MD5 hash of a UTF8 string
  26. LPAD in SQL Server 2008
  27. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  28. How do I remove non-breaking spaces from a column in SQL server?
  29. Is there an “IF EXISTS” test for a linked server?
  30. SQL Server stored procedure return code oddity

Leave a Comment