All Questions
Tagged with open-json sql-insert
2
questions
2
votes
1
answer
1k
views
How to Update and Insert Array of Objects in table with OPENJSON and where conditions
I want to update and insert the stock, InvM, and Invoice table with OPENJSON(). I am new at OPENJSON() in SQL Server. I have an array of objects and I want to insert each object to new row of the ...
0
votes
0
answers
284
views
T-SQL - Inserting 3.5M rows increases the transaction log size to max
Following is the query I am using to parse 3.5M rows of JSON data and insert it into another table.
DECLARE @id_control bigint
DECLARE @batchSize bigint
DECLARE @results nvarchar(256)
...
- 11