|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have the following XML file
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <CONTENT id="_12072_1-3" > <TITLE value="wInsight Newsletter hello rodney"></TITLE> <TITLECOLOR>"3300CC"</TITLECOLOR> </CONTENT> Im using the following XDR file to import the file <?xml version="1.0" ?> <Schema xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:xml:datatypes" xmlns:sql="urn:schemas-microsoft-com:xml-sql" > <ElementType name="TITLE" dt:type="string" /> <AttributeType name="value"/> <ElementType name="TITLECOLOR" dt:type="string" /> <ElementType name="CONTENT" sql:relation="links"> <AttributeType name="id" required="yes" dt:type="string"/> <attribute type="id" sql:field="id"/> <element type="TITLE" sql:field="title"/> <attribute type="value" sql:field="title"/> <element type="TITLECOLOR" sql:field="titlecolor" /> </ElementType> </Schema> I am attemping to import this file into one table and i cant seem to find the correct XDR format to get the value attribure from TITLE and insert it into the table. Can anyone help?? |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Problems Importing and XML file into Sql Server 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|