Hi Phil,
Thank you very much for developing this feature, it's really great.
When I was using it, I found that if the content of json exceeds 200 bytes, the data will be truncated, so I modified the definition length of @token as follows
@token NVARCHAR(200),--either a string or object(org code)
@token NVARCHAR(MAX),--either a string or object(Michael Modify 20240228)
The error occurred in
SELECT @token=SUBSTRING(@JSON, @start+1, @END-1)
Hi Phil,
Thank you very much for developing this feature, it's really great.
When I was using it, I found that if the content of json exceeds 200 bytes, the data will be truncated, so I modified the definition length of @token as follows
@token NVARCHAR(200),--either a string or object(org code)
@token NVARCHAR(MAX),--either a string or object(Michael Modify 20240228)
The error occurred in
SELECT @token=SUBSTRING(@JSON, @start+1, @END-1)