Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Mar 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 values and more.

 Function   Description
ISJSON 

Tests whether a string contains valid JSON.

 JSON_VALUE 

Extracts a scalar value from a JSON string.

 JSON_QUERY 

Extracts an object or an array from a JSON string.

 JSON_MODIFY 

Updates the value of a property in a JSON string and returns the updated JSON string.

Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date