how to load json file from data base code example

Example 1: insert json into sql

SELECT *
FROM OPENJSON(@json)
 WITH (id int 'strict $.id',
       firstName nvarchar(50) 'strict $.info.name',
       lastName nvarchar(50) '$.info.surname',
       age int,
       dateOfBirth datetime2)

Example 2: sql server import json

SELECT ISJSON(@JSON)

Tags:

Sql Example

Related