What is the SQL Server JSON Export Process?

Asked By 30 points N/A Posted on -
qa-featured

Hi Guys!

I am not familiar in using JSON or Java Object Notation. I am not even sure the functionalities of json and how to use it on SQL database like MSSQL Server. Can anyone please tell me how the SQL server json export happens? Can anyone please provide the steps in exporting to json. Also, if you can show some of your sample codes, it will be very helpful. Please give some time to share your knowledge.

Thanks.

Ammelia Jesse

SHARE
Answered By 5 points N/A #149108

What is the SQL Server JSON Export Process?

qa-featured

Hi Ammelia,

Java Script Object Notation also known as JSON is language independent, open standard designed for data interchange.

This is also available in many programming languages. This is somehow used as an alternative to XML.

The filename extension is .Jason.

Apparently there’s no function that converts output of MySQL query into JSON. One way of doing this is to connect them with PHP. You may check the discussion about possible ways to export MySQL to JSON.

Hope it aids you in understanding JSON.

 

Related Questions