CODE EXAMPLE FOR JAVASCRIPT

sql server - Parse JSON string in sql

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.