Retreive Symbols in CDATA section TSQL

• crazsmith

  SSC Rookie

  Points: 44

  More actions

  November 23, 2009 at 8:27 pm

  #137090

  I have a comment section in my application. I pass xml doc to my procedure.

  I would like to store the CDATA section of my xml doc in a column without any conversion.

  declare @xml xml

  set @xml=

  '<response>

  <test>

  <![CDATA[<greeting>Hello, world!</greeting>]]>

  </test>

  </response>'

  select @xml.query('data(/response/test)')

  Select @xml

  select cast(@xml.query('data(/response/test)') as varchar(124))

  above query will give

  <greeting>Hello, world!</greeting>

  is there way to preserve the special characters in xquery result..

  something like..

  <greeting>Hello, world!</greeting>

  Thanks.

• crazsmith

  SSC Rookie

  Points: 44

  More actions

  November 23, 2009 at 9:06 pm

  #1083236

  Please ignore message. I found the solution.

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  July 27, 2010 at 10:24 am

  #1198827

  what was it? i got the same problem, thanks.

  www.sql-library.com[/url]