Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generating JSON from SQL Expand / Collapse
Author
Message
Posted Thursday, March 24, 2011 8:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:10 AM
Points: 2,534, Visits: 4,509
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/
Post #1083324
Posted Thursday, March 24, 2011 8:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:10 AM
Points: 2,534, Visits: 4,509
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/
Post #1083336
Posted Wednesday, March 6, 2013 4:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 4:16 AM
Points: 1, Visits: 0
For which language you are asking? if it c, then cson_sqlite3 opensource code
Post #1427293
Posted Thursday, December 26, 2013 11:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 2, 2014 7:23 AM
Points: 2, Visits: 4
I have the same question,did you find any way to solve it?
Post #1526082
Posted Thursday, January 2, 2014 7:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 2, 2014 7:23 AM
Points: 2, Visits: 4
Done.
Post #1527116
Posted Thursday, January 2, 2014 4:11 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 10:52 PM
Points: 42,083, Visits: 39,479
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."

Helpful Links:
How to post code problems
How to post performance problems
Post #1527316
Posted Thursday, June 4, 2015 12:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 8, 2016 4:34 AM
Points: 133, Visits: 1,830
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

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



~manoj | LinkedIn | Facebook | YouTube
Blog: SQLwithManoj.com
Post #1691496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse