SQL Server Insert JSON data with other external parameters

Question

I have this query:

INSERT INTO [clients] ([FirstName], [LastName])
    SELECT FirstName, LastName
    FROM OPENJSON(@JsonRequest)
    WITH
        (FirstName NVARCHAR(50),
         LastName NVARCHAR(50)
        )

Now I want to fill two more columns with ONE external parameter - @ID and one with a SQL Server function - CURRENT_TIMESTAMP. I can't figure out how to build the query

INSERT INTO [clients] ([FirstName], [LastName], [createdDate], [ID])
    SELECT FirstName, LastName
    FROM OPENJSON(@JsonRequest)
    WITH 
        (FirstName NVARCHAR(50),
         LastName NVARCHAR(50)
        ),
        CURRENT_TIMESTAMP,
        @ID

But this is not working...

marc_s · Accepted Answer · 2018-09-21 12:42:02Z

3

I think you just need to move the columns to the select part

INSERT INTO [clients] ([FirstName], [LastName], [createdDate], [ID])
    SELECT
        FirstName, LastName, CURRENT_TIMESTAMP, @ID
    FROM OPENJSON(@JsonRequest)
    WITH (
            FirstName NVARCHAR(50),
            LastName NVARCHAR(50)
         )

edited Sep 21, 2018 at 12:42

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 21, 2018 at 12:18

Brad

3,7253 gold badges32 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

iMarh Over a year ago

Its OK now. Thank you!

Collectives™ on Stack Overflow

SQL Server Insert JSON data with other external parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related