SQL SERVER 2008 to Json

Question

SQL SERVER 2008 to Json

datelligence

Say Hey Kid

Points: 672
More actions
May 2, 2012 at 3:21 pm

#260246

Hi, I need to query data from a MSSQL server 2008 table and parse it in JSON. Have any ideas.
Need to query any table.
Need to pass the query result to a JSON parser in classin ASP or PHP.
By no means, ASP.NET.
Thanks
Jorge

Viewing 3 posts - 1 through 2 (of 2 total)

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

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

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

Alan Burstein SSC Guru Points: 61141 More actions · Answer 2

datelligence (5/2/2012)
Hi, I need to query data from a MSSQL server 2008 table and parse it in JSON. Have any ideas.
Need to query any table.
Need to pass the query result to a JSON parser in classin ASP or PHP.
By no means, ASP.NET.
Thanks
Jorge

Note this article by Phil Factor:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001