Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI have problems using namespaces when using SQLXMLBulkLoad Starting from the example http://msdn2.microsoft.com/en-us/library/ms171806.aspx part D. Bulk loading in identity type columns If the xml should be changed to <ROOT xmlns="http://tempuri.org/schema.xsd" > <Order OrderID="11" CustomerID="ALFKI"> <Product ProductID="11" ProductName="Chai" /> <Product ProductID="22" ProductName="Chang" /> </Order> <Order OrderID="22" CustomerID="ANATR"> <Product ProductID="33" ProductName="Aniseed Syrup" /> <Product ProductID="44" ProductName="Gumbo Mix" /> </Order> </ROOT> What would be done to the schema to make it work? Any ideas? -- Christopher Schmidt Rehfeld A/S
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread