Post reply

Urgent !!How to store and Retrive the XML data in SQL Server 2000

  • November 23, 2007 at 5:40 am

    #61407

    We are not able to store XML data in SQL Server 2000 table.

    even though the table.

    The column have been designed to Varchar(max), then ntext etc

    but the data get truncated.

    Please help

    Regards,

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • November 23, 2007 at 6:11 am

    #753614

    On 2000 there is no varchar(max), but it is common to use ntext or image for xml.

    When you say it gets truncated, does it get truncated when you query it or when you modify it? Management Studio/Query Analizer truncates long strings it retrieves, you can change this in it options.

    You can check the length of items using the datalength(columnname) function

    select top 1 datalength(mycolumn) from mytable

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

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

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