March 17, 2017

Built-in JSON Functions in SQL

Did you know that SQL has built-in JSON functions? These can come in very handy! Instead of creating a very complicated query that exports XML and then translate it to JSON through a third party, you can use the following JSON SQL functions to identify valid JSON strings, extract JSON