Home Forums Programming XML how to insert xml declaration RE: how to insert xml declaration

  • October 22, 2015 at 10:16 am

    #1834969

    sam-433147 (10/22/2015)

    OK

    I see what you mean

    but what about xml that exceed the varchar(max)?

    If it exceeds the 2Gb limit then you have two options, chop it into 2GB chunks or export it straight into a file without trying to manipulate it within SQL.

    😎