Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2011-03-15 : 14:12:10
|
| must each complexType go to a separate table in the DB. I have a xsd in this QualifierType and QualifierFamily are again complex types(one occurrance inside Qualifier). Is there a way for me to get Qualifier, QualifierTypeid,QualifierDescription(from the QualifierType complexType) , QualifierFamilyId,QualifierFamilydescription(from the QualifierFamily complex type) all in one table? <xs:element name = "Qualifier" sql:relation="MOTOR_Qualifier"> <xs:complexType> <xs:sequence> <xs:element ref = "QualifierDescription" maxOccurs = "unbounded"/> <xs:element ref = "QualifierType"/> <xs:element ref = "QualifierFamily"/> </xs:sequence> <xs:attribute name = "id" use = "required" type = "xs:string" sql:field="Qualifier_ID" sql:mapped="1"/> </xs:complexType>thanks in advanceAAAV |
|
|
|
|
|
SQLXMLBulkLoad.