Forum Replies Created

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

  • Reply To: QUOTENAME Behavior

    DECLARE @s-2 VARCHAR(20) = 'Steve Jones'

    SELECT QUOTENAME(@s, '>') as 'a',

    QUOTENAME(@s, '<') as 'b',

    QUOTENAME(@s, '><') as 'c',

    @@VERSION as ver

    FOR XML PATH(''), TYPE

    -->>

    &lt;Steve Jones&gt;

    <b>&lt;Steve Jones&gt;</b>

    <c>&lt;Steve Jones&gt;</c>

    <ver>Microsoft SQL Server 2025 (RTM-GDR) (KB5091223) -...

  • Reply To: 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...

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