sql 将结果集反系列化为json

函数如下：create function [UFJson](@code varchar(100),@json nvarchar(2000))returns nvarchar(500)ASBEGIN    declare @codeindex as int    declare @valueindex as int    declare @endindex as int    set @codeindex = charindex(@code,@json)    --没有找到code项    if (@codeindex = 0) return ''        set @valueindex = charindex(':',@json,@codeindex)    set @endindex = charindex(',',@json,@codeindex)            if (@endindex = 0) set @endindex = charindex('}',@json,@codeindex)        --格式不对 return ''    if (@valueindex = 0 or @endindex = 0) return ''            --正常返回    return substring(@json,@valueindex+1,@endindex-@valueindex-1)ENDGO

调用方式：@json='{"free":30,"first":1,"first fee":10,"per":30,"per fee":1.5}'select dbo.UFJson('per',@json)