cnblogs index pan reat font blog var bstr
- CREATE FUNCTION [dbo].[fn_parsejson]
- (@p_jsonstr VARCHAR(8000),
- @p_key VARCHAR(200))
- RETURNS VARCHAR(MAX)
- AS
- BEGIN
- RETURN SUBSTRING(@p_jsonstr,CHARINDEX(‘"‘+@p_key+‘":‘,@p_jsonstr)+LEN(@p_key)+4,CHARINDEX(‘"‘, SUBSTRING(@p_jsonstr,CHARINDEX(@p_key,@p_jsonstr)+LEN(@p_key)+3,LEN(@p_jsonstr)))-1)
- END
SQL json字符串解析
来源: http://www.bubuko.com/infodetail-2305329.html