XML to SQL

Results 1 to 2 of 2

Thread: XML to SQL

  1. #1
    Assaf Guest

    Default XML to SQL

    How about getting an XML structure back into SQL SERVER ?<BR>say , an update action ?<BR>Has anyone implemented this in any way ?

  2. #2
    Join Date
    Dec 1969
    Posts
    569

    Default RE: XML to SQL

    Until I get a better understanding of using XML and SQL Server. I have made the following compromise. I store fields from the XML that I need to be able to sort by within SQL as a column and then store the XML as ntext. Which will make searches for a specific date quick using stored procedures. And then I have an easier way of reporting the data using the XML data and an XSLT file.<BR><BR>Sorry if that doesn&#039t make sense. I&#039ve been up since 8am and I can&#039t go home yet :-)<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •