Help with xml to text

• baumgaertner

  Ten Centuries

  Points: 1344

  More actions

  May 5, 2009 at 5:45 am

  #130530

  I want to convert values from a xml column into a text column.

  Example:

  UPDATE tblTest

  set textData = Convert(text,xmlData)

  Any idea how to realize that?

  Thanks.

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 5, 2009 at 5:57 am

  #988683

  Hi

  You have to convert your XML to NVARCHAR(MAX), then you can insert into a TEXT column:

  UPDATE @t SET MyText = CONVERT(NVARCHAR(MAX), MyXml

  Two things:

  * TEXT data type is marked as deprecated in SSE2k5 and will be removed in future versions (SSE2k8 still supports)

  * XML is Unicode, so you should use NTEXT (better NVARCHAR(MAX)).

  Greets

  Flo

• baumgaertner

  Ten Centuries

  Points: 1344

  More actions

  May 5, 2009 at 8:17 am

  #988838

  Thanks. It works.