Home » Science & Technology » How to load JSON file to SQL Server?

How to load JSON file to SQL Server?

Written By Coding Studio on Sunday, Jul 03, 2022 | 10:28 AM

 
Demonstrates how JSON document can be loaded to SQL Server. T-SQL SCRIPT: declare @json_data varchar(max) select @json_data = BulkColumn from openrowset ( BULK 'C:\temp\test.json', SINGLE_CLOB ) as datasource --print @json_data insert into emp (emp_name, emp_address,phone, age) select Name, Address, Phone, Age from openjson (@json_data) WITH ( Name varchar(20), Address varchar(20), Phone varchar(20), Age int ) select * from emp Hope, it was helpful. Thanks you! Next video: Convert JSON to CREATE TABLE Statements #json #sqlservertutorial #sqlserver #sqlservermanagementstudio

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.