Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/JSON.sql

Last active Apr 11, 2017
Embed
What would you like to do?
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.