Showing posts with label OPENROWSET. Show all posts
Showing posts with label OPENROWSET. Show all posts

Friday, April 24, 2026

.::: Read Json file using OPENJSON, OPENROWSET in SQL Server :::.


 

1. copy json sample to disk C:\bcp\teguhth.pembelian.json
 
 



2. only read json 

 

Thursday, April 23, 2026

.::: Export MSSQL SQL Server to csv using OPENROWSET :::.

 

https://teguhth.blogspot.com/2025/12/backup-restore-table-sql-server-using.html

https://teguhth.blogspot.com/2026/04/sample-lab-using-openrowset-in.html

1. create excel dummy with header save as "openrowsori.xlsx"
 

2. replace openrows.xlsx (


copy openrowsori.xlsx openrows.xlsx

Karena Excel (via Microsoft ACE OLEDB):

tidak support DELETE
tidak support TRUNCATE
tidak support OVERWRITE

Thursday, April 9, 2026

.::: Sample lab Using OPENROWSET in Microsoft SQL Server 2025 (read excel csv from sql server) :::.

 

A. prerequirement

1. prerequirement 
Access Database Engine 2016 (x64)

https://www.microsoft.com/en-us/download/details.aspx?id=54920

2. enable access service 
 


3. AKTIFKAN OPENROWSET


Di Microsoft SQL Server:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;

EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;

 

Popular Posts