Extract Values from JSON String Column in SQL Server

Raymond Tang Raymond Tang 0 3238 1.45 index 5/29/2019

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;
mssql sql-server t-sql

Join the Discussion

View or add your thoughts below

Comments