February 3, 2004 at 9:32 am
Hello, first any suggestions are well come on this subject. I have an XML doc which contains data for multiple tables. These tables are highly normalized with relationships and constraints. My question is, what is the easiest way of accomplishing this task (DTS/Custom SP/ What?). I initial knowledge suggest that using a custom SP with the OPENXML function (since my knowledge in XML and SQL is very little) but is this the best way? I have been doing some reading and I am hearing XSD and Updategrams, can these help with this task? Any suggestion is okay, since I have no idea how to implement this. Thanks in advance
February 6, 2004 at 8:00 am
This was removed by the editor as SPAM
February 11, 2004 at 1:35 am
I'm surprised no one has helped you out yet. I would probably go the OPENXML method. Have the XML passed into an SP as a parameter of type text or ntext and then manipulate the XML in the SP using the OPENXML. You can use OPENXML to get just the information you want so you can easily separate out each tables data into logical code breaks. This will make it much easier to figure out what you need to do. I'll try and post some sample code tomorrow if I get a chance.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply