Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

9
  • This is some great functionality but does have some limitations e.g. stripping the "-" from negative numbers.
    – Gavin
    Commented Apr 25, 2012 at 22:02
  • very cool! you have one typo in the script: IF OBJECT_ID (N'dbo.parseJSON') IS NOT NULL DROP FUNCTION dbo.JSONEscaped GO -- should test for dbo.JSONEscaped in the IF test.
    – isapir
    Commented Apr 18, 2013 at 18:36
  • @phil dbo.parseJSON is working very slow in case of large data. so can we reduce the time of that by using any other methods within that?
    – cracker
    Commented Apr 16, 2014 at 4:48
  • I'm curious, what do you think about newly added native JSON support of SQL Server 2016? Commented Aug 21, 2016 at 1:32
  • This is awesome, but is there a way to make it not strip the "-" from negative numbers? I can't quite figure out where or why that happens... Commented Oct 25, 2016 at 15:16