![]() |
Chilkat HOME Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi DLL Go Java Node.js Objective-C PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) Load JSON Data at PathDemonstrates how to load JSON data into a path within a JSON database. For example, we begin with this JSON: { "a": 1, "b": 2, "c": { "x": 1, "y": 2 } }Then we load {"mm": 11, "nn": 22} to "c", and the result is this JSON: { "a": 1, "b": 2, "c": { "mm": 11, "nn": 22 } } Note: This example requires Chilkat v11.0.0 or greater.
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- Demonstrates how to load replace the data at a location within a JSON database. DECLARE @p nvarchar(4000) SELECT @p = '{"a": 1, "b": 2, "c": { "x": 1, "y": 2 } }' DECLARE @json int EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @json, 'Load', @success OUT, @p EXEC sp_OASetProperty @json, 'EmitCompact', 0 EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT PRINT @sTmp0 DECLARE @q nvarchar(4000) SELECT @q = '{"mm": 11, "nn": 22}' DECLARE @c int EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @c OUT EXEC sp_OAMethod @json, 'ObjectOf2', @success OUT, 'c', @c EXEC sp_OAMethod @c, 'Load', @success OUT, @q -- See that x and y are replaced with mm and nn. EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @c END GO |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.