Parse JSON string in sql

Question

I have a column of JSON strings in my table, I'm using SQL Server 2008. Any Ideas on how to parse the JSON string and extract a specific value?

Here's my JSON String:

{"id":1234,"name":"Lasagne al frono","description":"Placerat nisi turpis, dictumst nasceture ete etiam mus nec cum platea tempori zillest. Nisi niglue, augue adipiscing ete dignissim sed mauris augue, eros!","image":"images/EmptyProduct.jpg","cartImage":"images/ArabianCoffee.jpg","basePrice":54.99,"priceAttribute":"itemPrice","attributes":[{"type":"Addons","label":"Side","attributeName":"Side","display":"Small","lookupId":8},{"type":"Addons","label":"Drink","attributeName":"drink","display":"Small","lookupId":5},{"label":"add note","type":"Text","attributeName":"notes","display":"Wide","lookupId":null}]}

I need to extract the value of "name", Any Help?

Almost dup of Parse JSON in TSQL, which asks with a parameter as a source instead of a column, but have good answers and now mention the native JSON support in SQL Server 2016. — Frédéric
– Frédéric, Commented Feb 26, 2016 at 12:40

Sam Peacey · Accepted Answer · 2012-09-02 11:47:15Z

8

Since sql server has no JSON support built in, you'd need to parse this manually, which would get complicated.

However, you could always use somebody else's JSON parsing library.

answered Sep 2, 2012 at 11:47

Sam Peacey

6,0341 gold badge28 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

András Ottó · Accepted Answer · 2012-09-02 11:52:42Z

2

For parsing JSON you can write an easy CLR Function in C# or VB.NET.

answered Sep 2, 2012 at 11:52

András Ottó

7,7351 gold badge30 silver badges38 bronze badges

Comments

Beth Lang · Accepted Answer · 2016-12-28 23:54:20Z

2

Now you can use MS SQL Server 2016

https://msdn.microsoft.com/en-us/library/dn921897.aspx

answered Dec 28, 2016 at 23:54

Beth Lang

1,89018 silver badges38 bronze badges

Collectives™ on Stack Overflow

Parse JSON string in sql

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related