Click here to get back home

XML to Database
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
XML to Database worlman385 03-22-2008
Posted by worlman385 on March 22, 2008, 4:52 am
Please log in for more thread options
 I am now using SQLXML to load XML file into a SQLServer database.

Here is how it works -

XML(Data) + XSD(Schema) -->

through MS SQLXML COM program (EXE) -->

SQLServer2005

==================

I though XML Schema is used for defining what kind of Element or
attribute should appear in an XML document right?

But from above example, XSD schema can also used to describe how XML
document should be map to a Database table too???

Then XSD can be think of a document that describe how One want to
manipulate a specific XMLfile?

So, XSD schema to be used to describe anything about data manipulate
of an XML???

Above is the only use of XSD schema?

Posted by Tad J McClellan on March 22, 2008, 3:07 pm
Please log in for more thread options

> I though XML Schema is used for defining what kind of Element or
> attribute should appear in an XML document right?
>
> But from above example, XSD schema can also used to describe how XML
> document should be map to a Database table too???
>
> Then XSD can be think of a document that describe how One want to
> manipulate a specific XMLfile?
>
> So, XSD schema to be used to describe anything about data manipulate
> of an XML???
>
> Above is the only use of XSD schema?


This is the Perl newsgroup.

We discuss things related to the Perl programming language here.

Not one of your questions is related to the Perl Programming language.

You are in the wrong newsgroup.


--
Tad McClellan
email: perl -le "print scalar reverse qq/moc.noitatibaher0cmdat/"

Similar ThreadsPosted
FAQ: How do I use an SQL database? October 21, 2004, 5:10 am
FAQ 8.41 How do I use an SQL database? March 17, 2005, 6:03 am
FAQ 8.41 How do I use an SQL database? May 30, 2005, 5:03 pm
FAQ 8.41 How do I use an SQL database? September 18, 2005, 4:03 am
FAQ 8.41 How do I use an SQL database? September 19, 2006, 9:03 am
FAQ 8.41 How do I use an SQL database? May 30, 2007, 3:03 am
FAQ 8.41 How do I use an SQL database? August 18, 2007, 3:03 am
FAQ 8.41 How do I use an SQL database? March 15, 2007, 4:03 am
FAQ 8.41 How do I use an SQL database? November 8, 2007, 9:03 pm
FAQ 8.41 How do I use an SQL database? January 23, 2008, 9:03 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap