What is the SQL Server JSON Export Process?

Asked By Ammelia Jesse 30 points N/A Posted on - 04/27/2013

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

• Status: Open
• Question Views: 1438
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Holloway Hively 5 points N/A #149108

What is the SQL Server JSON Export Process?

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.

 

About Holloway Hively

Questions
2

Answers
102

Best Answers
45

• Vote Up 0 Vote Down

• Posted on - 05/16/2013
• Question Category: MS SQL Server