Answers for "sql server import data from json file"

sql server import json

DECLARE @JSON VARCHAR(MAX)

SELECT @JSON = BulkColumn
FROM OPENROWSET 
(BULK 'C:file-locationmy-data.json', SINGLE_CLOB) 
AS j

Posted by: Guest on January-03-2021

sql server import json

If (ISJSON(@JSON)=1)
SELECT @JSON AS 'JSON Text'

Posted by: Guest on January-03-2021

Code answers related to "sql server import data from json file"