This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server 2016 introduced the support of JSON and added many new functions in the recent CTP3 version of SQL Server 2016.
Now, we have OPENJSON() to extract JSON data into a tabular format. If you are passing JSON document as an input parameter in Stored Procedure, you can use OPENJSON() to extract the value of JSON parameter.
SQL Server 2016: Introduced JSON support, to store and retrieve JSON document
Please check the below sample use of OPENJSON():
Sample 1:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
DECLARE @SampleJson NVARCHAR(2000) = N'{ "ID" : 1, "Name": "Anvesh", "Blog": "dbrnd.com", "DOB": "1988-01-26", "Position": "Database Engineer" }' GO SELECT * FROM OPENJSON(@SampleJson) GO |
Sample 2:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
DECLARE @SampleJson NVARCHAR(2000) = N'[{ "ID" : 8, "Name": "Anvesh", "Blog": "dbrnd.com", "DOB": "1988-01-26", "Position": "Database Engineer" } ,{ "ID" : 10, "Name": "Roy", "Blog": "abc.com", "DOB": "1920-06-8", "Position": "Database Developer" }]' GO SELECT * FROM OPENJSON(@SampleJson) with ( ID INT, Name NVARCHAR(2000), Blog NVARCHAR(20), DOB DATE, Position NVARCHAR(20) ) GO |
Leave a Reply