[转]在SqlServer中解析JSON数据:CREATE FUNCTION dbo . parseJSON ( @JSON NVARCHAR ( MAX )) RETURNS @hierarchy TABLE ( element_id INT IDENTITY ( 1 , 1 ) NOT NULL, /* internal surrogate primary key gives the order of parsing and the list order */ sequenceNo [int] NULL, /* t