TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
unathi guma
NA
40
9.8k
Error on a stored proc
Mar 11 2019 7:02 AM
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
--dbo.tbl_SubmissionsMaster([pk_DataSetId, CompleteDate, Period, OrgUnit, DataValues, SubmittedTS, ResubmittedTS])
-- Insert statements for procedure here
SELECT
*
FROM
OPENJSON (@json)
WITH
(
DataSetId uniqueidentifier
, CompleteDate DateTime
, period datetime
, OrgUnit
varchar
(50)
, DataValues
varchar
(200)
, SubmittedTS DateTime
, ResubmittedTS DateTime
)
END
GO
Reply
Answers (
6
)
How to Host user control in datagridview cell C# Winform
Why i choose .Net core?