JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON. 

From SQL Server 2016 on wards, JSON functions are commonly supported. You can use JSON_VALUE function to extract data from JSON columns.

Refer to the following page about more details of JSON functions:

JSON Functions (Transact-SQL)

Code snippet

WITH JSON_STR AS
(
select '{"Name":"A","Value":2}' as JSON_COLUMN
)
SELECT json_value(JSON_COLUMN, '$.Name') as Name,
json_value(JSON_COLUMN, '$.Value') as Value
from JSON_STR;
info Last modified by Raymond at 2 years ago * This page is subject to Site terms.

More from Kontext

local_offer mssql local_offer t-sql

visibility 23
thumb_up 0
access_time 8 months ago

This code snippet shows how to calculate time differences.

open_in_new Code snippets

local_offer mssql local_offer t-sql

visibility 16
thumb_up 0
access_time 8 months ago

This code snippet shows how to convert string to date.

open_in_new Code snippets

local_offer mssql local_offer t-sql

visibility 16
thumb_up 0
access_time 8 months ago

In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name. 

open_in_new Code snippets

local_offer mssql local_offer t-sql

visibility 32
thumb_up 2
access_time 8 months ago

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

open_in_new Code snippets

info About author

comment Comments (0)

comment Add comment

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

No comments yet.

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.


Learn more arrow_forward