Creating JSON I

  • Comments posted to this topic are about the item Creating JSON I

  • DECLARE @a JSON

    SET @a = JSON_OBJECTAGG( 'City':'Denver')

    SELECT @@VERSION ver, @a json

    ver: Microsoft SQL Server 2025 (RTM-GDR) (KB5073177) - 17.0.1050.2 (X64)   Dec 15 2025 20:07:57   Copyright (C) 2025 Microsoft Corporation  Enterprise Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 26200: ) (Hypervisor)

    json:{"City":"Denver"}

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply