More than 5 years have passed since last update.

SQL Server2016 OPENJSON使い方

SQLServer
JSON

Posted at 2016-07-11

SQL Server2016 OPENJSON使い方

sample.sql

DECLATE @param1 navarchar(50);
DECLATE @param2 nvarchar(50);

SELECT @param1=myou, @param2=name FROM OPENJSON( N'{"myou":"山田","name":"太郎"}' )
 WITH ( myou nvarchar(50) '$.myou' , name nvarchar(50) '$.name' )

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up