JSON support in SQL Server (read – write statistics) – Part 5

Loading Entire content of JSON file using  OPENROWSET (BULK) table-valued function, SQL Server will read the entire content of the file and insert it into SQL Server (Total Execution time = Time spent on Reading the full content of file + Writing the document into the table)

In below example, Importing JSON file of size 3.50 MB

Loading  JSON document with OPENROWSET (BULK) & CROSS APPLY OPENJSON()

Leave a Reply

Your email address will not be published. Required fields are marked *