JSON.sql

CREATE PROC [dbo].[usp_InsertDemoJSON] @json AS nvarchar(max)
AS
BEGIN
	INSERT INTO Demo ([Key],[Value]) 
	SELECT *  
	FROM OPENJSON(@json) 
	WITH ([Key] int, [Value] varchar(50))
END