By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

How to extract json from a relational db?

P: 1
I donít like writing a lot of procedural code, and so Iíd like to know a common way to extract data from relational tables and move it into hierarchical json.

Right now, I am using MS SQL Server database, but I would like to perform this migration using My SQL database also.

I am using java and java connectivity database for access. Iíd prefer any of these two databases to be able to assemble all the records on the server side.
Nov 13 '13 #1
Share this Question
Share on Google+
1 Reply


P: 4
Hi,

First of all, SQL Server itself doesnít support json, so youíll need to figure out your own way if you want to accomplish this.

To help you, Iíve found a good post illustrating a number of string manipulation techniques in TSQL:
https://www.simple-talk.com/sql/t-sq...in-sql-server/
Nov 13 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.