Timeline for Parse JSON in TSQL
Current License: CC BY-SA 3.0
12 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 19, 2018 at 12:33 | comment | added | kgzdev |
In database with Turkish_CI_AS Collation: parseJSON function query should replace variable names from parent_id to parent_ID and from string_id to string_ID to execute. Great work, thank you Phil!
|
|
Oct 11, 2017 at 12:32 | comment | added | Jigar | We are facing issue when StringValue is more than 4K size. Anyone has encounter such issue. We have comment field where we have NVarchar(Max) size. Does anyone has face this issue? What is solution for the same? | |
Feb 9, 2017 at 1:43 | comment | added | Baz Guvenkaya |
To make the json as variable instead of using json strings: declare @config varchar(1000) select @config = config from mytable (nolock) where id = 1 exec ('Select * from parseJSON(''' + @config + ''')')
|
|
Feb 7, 2017 at 13:31 | comment | added | iamdave | @NikolineHejbøl There is a fix for the negative number stripping in the comments: simple-talk.com/sql/t-sql-programming/… | |
Oct 25, 2016 at 15:16 | comment | added | Nikoline Hejbøl | 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... | |
Aug 21, 2016 at 1:32 | comment | added | Free Consulting | I'm curious, what do you think about newly added native JSON support of SQL Server 2016? | |
S Nov 23, 2015 at 9:58 | history | suggested | H. Pauwelyn | CC BY-SA 3.0 |
added code
|
Nov 23, 2015 at 9:20 | review | Suggested edits | |||
S Nov 23, 2015 at 9:58 | |||||
Apr 16, 2014 at 4:48 | comment | added | cracker | @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? | |
Apr 18, 2013 at 18:36 | comment | added | isapir | 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. | |
Apr 25, 2012 at 22:02 | comment | added | Gavin | This is some great functionality but does have some limitations e.g. stripping the "-" from negative numbers. | |
Nov 15, 2010 at 18:02 | history | answered | Phil Factor | CC BY-SA 2.5 |