Скачать
How to load JSON file to SQL Server?
Автор: Coding Studio
Загружено: 2022-07-03
Просмотров: 21642
Описание:
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![[2026] Feeling Good Mix - English Deep House, Vocal House, Nu Disco | Emotional / Intimate Mood](https://imager.clipsaver.ru/cxLdtvzf2sI/max.jpg)
