Sql server allows you to parse Json data with OpenJson .
Sample Json data : [{“MinValue”:”1″,”MaxValue”:”6″}]
Parsing Json to map into Tables:
declare @metadata="[{"MinValue":"1","MaxValue":"6"}]"
select Minvalue,MaxValue from openjson(@metadata)
with (MinValue nvarchar(2),MaxValue nvarchar(2));
