You can transfer data with JSON in SQL Server. Based on an SQL query, you can output the results into JSON format. Here is a small example:
DECLARE @JSONOutput NVARCHAR(MAX) =
(SELECT * FROM Students FOR JSON auto, INCLUDE_NULL_VALUES)
Print @JSONOutput;
This could potentially give the following result:
[
{
"StudentID":1,
"StudentName":"Hannes",
"EnrolDate":"2017-12-14T14:19:22.273"
},
{
"StudentID":2,
"StudentName":"Elmarie",
"EnrolDate":"2017-12-13T13:19:22.273"
},
{
"StudentID":3,
"StudentName":"Kayla",
"EnrolDate":"2017-12-15T15:19:22.273"
}
]
Visit the DevX Tip Bank