Search

Advertisements

Showing posts with label JSON. Show all posts
Showing posts with label JSON. Show all posts

Microsoft Azure - Move data from another computer to SQL Server instance on VM using SSIS

In this article, let us see on how to move data from another computer over internet to SQL Server instance on virtual machine using SSIS.

If you have no idea in creating and connecting to Azure SQL Server VM, Please refer below links :




In this post, let us also see on how to import JSON file on local computer to SQL Server on VM through this example.


SQL Server Import (Bulk load) JSON file into table

In SQL Server 2016, Microsoft provides built-in support for importing, exporting, parsing, and querying JSON documents or fragments.

In this article, let us see on how to import JSON data into SQL Server table.

Using OPENROWSET is one of the option to bulk load JSON data into SQL Server table.

SQL Server JSON - Examples - JSON_QUERY, JSON_VALUE

In this post, let us see some examples on handling JSON data in SQL Server using JSON_QUERY, JSON_VALUE

Consider below sample JSON data, let us check whether it is valid :

{"MSSQL":
      {  
 "SQL Server":{  
"Version":"6.0",
"CompatibilityLevel":60,
"CodeName":"SQL95" },
"YearofRelease":"1995"  
      }
 

}

SQL Server - Convert JSON data into relational data (rows & columns) format

In my previous post, I shared some examples on Converting relational data to JSON data in SQL Server.


In this post, let us see examples for converting JSON data into relational data format.

For Example: Consider below JSON data :

SQL Server - Split CSV into separate row and other splitting techniques using OPENJSON

In SQL Server 2016, Microsoft provides built-in support for importing, exporting, parsing, and querying JSON documents or fragments.

In this article, let us see some examples on splitting comma separated string into separate rows using OPENJSON

 --Split comma separated numeric
SELECT value FROM OPENJSON('[1,2,3]')

-- Split comma separated alphabets
SELECT value FROM OPENJSON('["A","B","C"]')

--Ignore null while splitting

SQL Server - Convert relational data to JSON data


In SQL Server 2016, Microsoft provides built-in support for importing, exporting, parsing, and querying JSON documents or fragments.

In this article, let us see examples on how to convert relational data (data in rows & columns format) to JSON format

Advertisements