Forum Replies Created

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

  • RE: XML Storage

    BTW, I remove space and newline from @n

    hong1tao (7/23/2008)

    change sql as below

    DECLARE @x xml,

    @n varchar(1000);

    SET @n = N' ';

    SET @x = CAST(@n AS xml);

    SELECT 'varchar length = ',...

    July 23, 2008 at 2:48 pm

    #847386

  • RE: XML Storage

    change sql as below

    DECLARE @x xml,

    @n varchar(1000);

    SET @n = N' ';

    SET @x = CAST(@n AS xml);

    SELECT 'varchar length = ', DATALENGTH(@n)

    UNION

    SELECT 'xml length = ', DATALENGTH(@x);

    result is...

    July 23, 2008 at 12:35 am

    #846839

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