SQL Server - Handling JSON data

SQL Server - Convert relational data to JSON data
http://www.allaboutmssql.com/2015/12/sql-server-convert-relational-data-to.html


SQL Server - Split CSV into separate row and other splitting techniques using OPENJSON
http://www.allaboutmssql.com/2015/12/sql-server-split-csv-into-separate-row.html

SQL Server - Convert JSON data into relational data (rows & columns) format
http://www.allaboutmssql.com/2015/12/sql-server-convert-json-data-into.html

SQL Server JSON - Examples - JSON_QUERY, JSON_VALUE
http://www.allaboutmssql.com/2015/12/sql-server-json-examples-jsonquery.html

SQL Server Import (Bulk load) JSON file into table
http://www.allaboutmssql.com/2015/12/sql-server-import-bulk-load-json-file.html

Microsoft Azure - Move JSON data from another computer to SQL Server instance on VM using SSIS
http://www.allaboutmssql.com/2015/12/microsoft-azure-move-data-from-another.html

No comments: