Parse Json String In Sql

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,'n

Solution 1:

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.

Solution 2:

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

Solution 3:

Now you can use MS SQL Server 2016

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