Generating JSON from SQL

Question

Generating JSON from SQL

Ray K

SSC-Dedicated

Points: 31169
More actions
March 24, 2011 at 8:04 am

#234528

Does anyone know of (or can recommend) a resource that tells me how to convert SQL query results into JSON format?
Thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ray K SSC-Dedicated Points: 31169 More actions · Answer 1

I might've just partially answered my own question. I found this link: http://www.json.org/. I'm about to poke around and see what I find.

However, if anyone else has any suggestions, I'm all ears!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

murali248641 Newbie Points: 9 More actions · Answer 2

For which language you are asking? if it c, then cson_sqlite3 opensource code

Emptymoon Grasshopper Points: 12 More actions · Answer 3

I have the same question,did you find any way to solve it?

Emptymoon Grasshopper Points: 12 More actions · Answer 4

Emptymoon

Grasshopper

Points: 12

January 2, 2014 at 7:25 am

#1676904

Done.

Jeff Moden SSC Guru Points: 1004565 More actions · Answer 5

Emptymoon (1/2/2014)
Done.

Please share. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

manub22 Hall of Fame Points: 3163 More actions · Answer 6

Well with SQL Server 2016 you can export SQL table rows into JSON string format. JSON in SQL will just work like XML with similar semantics.

Check this: Export SQL table to JSON string[/url]

MSDN BoL on JSON & SQL: https://msdn.microsoft.com/en-us/library/dn921882(v=sql.130).aspx

~manoj | LinkedIn | Facebook | YouTube
Blog: SQLwithManoj.com

Generating JSON from SQL

Cookies on SQLServerCentral