Convering ntext into xml datatype in sql server 2000

• Soundari

  SSC Eights!

  Points: 846

  More actions

  November 23, 2009 at 10:56 pm

  #156431

  Hi

  I having XML data stored in SQL server 2000 as ntext datatype. MY XML is stored in the form

  <?xml version="1.0" standalone="yes"?>

  <?xml-stylesheet type='text/xsl' href='Certificate.xsl'?>

  <Certificate>

  <Applicant>

  <TalukName>Kancheewaram</TalukName>

  <HobliName>XYZ</HobliName>

  ........

  </Applicant>

  </Certificate>

  There is no UTF used. This I want to convert as XML datatype in a query and same output I want to use it in Reporting Services. Is it possible?

  With Regrds

  Soundari

• SwePeso

  SSC-Dedicated

  Points: 39725

  More actions

  November 24, 2009 at 12:55 am

  #1083320

  Have you tried "CONVERT(XML, YourColumnNameHere)"?

  ---

  N 56°04'39.16"
  E 12°55'05.25"