Top "Open-json" questions

OpenJson is a T-SQL (SQL Server) built in table valued function, introduced in 2016 version.

SQL Server OPENJSON read nested json

I have some json that I would like to parse in SQL Server 2016. There is a hierarchy structure of Projects-&…

Read More
json parsing hierarchy sql-server-2016 open-json
SQL Server Invalid version: 15 (Microsoft.SqlServer.Smo)

Context: I'm having difficulty modifying a stored procedure in SQL Server 2016. The stored procedure performs parsing of json data within …

Read More
sql-server tsql open-json
JSON text is not properly formatted. Unexpected character ''' is found at position 1

Question: Why am I unable to apply the OPENJSON function to read the data below into standard columnar form? How …

Read More
python sql json sql-server open-json