I am creating a stored proc to insert JSON data on the DB and I am getting an error. See my code below.
- CREATE PROCEDURE InsertJson
- @json NVARCHAR(MAX)
- AS
- BEGIN
- INSERT INTO dbo.tbl_SubmissionsMaster
-
- SELECT *
- FROM OPENJSON (@json)
- WITH(
- DataSetId uniqueidentifier
- , CompleteDate DateTime
- , period datetime
- , OrgUnit varchar(50)
- , DataValues varchar(200)
- , SubmittedTS DateTime
- , ResubmittedTS DateTime
- )
- END
- GO