Re: How do you read an XML schema in SQL 2005

You would need to create an XML schema collection. Check out CREATE XML
SCHEMA COLLECTION in BOL. Once you've created an XML schema collection you
can create typed XML instances like this:

DECLARE @x XML (schema_collection_name);


"Dee" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CE404920-A3B1-4114-A576-CFD107AF4B35@xxxxxxxxxxxxxxxx
I have some data that came to me in XSD. How can this be read into an SQL
2005 database? I also have a few XML Schemas and need to know how this
can
be ready into an SQL 2005 database?

Thanks for any help
Dee


.

Relevant Pages

  • Re: How do you read an XML schema in SQL 2005
    ... there doc on getting the information in the database? ... This is an OAGIS® BOD XML Schema Definition. ... Weight values are reflected in single numbers in pounds with 3 ... SCHEMA COLLECTION in BOL. ...
    (microsoft.public.sqlserver.xml)
  • Re: Specifying typed xml parameter in CLR stored procedure
    ... manually specifying the schema collection for the parameters in CREATE ... > Is there any way to specify the XML schema for SqlXml parameter in the CLR ...
    (microsoft.public.sqlserver.xml)
  • Re: GetChanges hangs application
    ... It is easy to abuse a dataset as a database, but the truth of the matter is ... what kind of XML Schema will it take to represent 40 ... Now loading Xml Schema in a loop is something that it might ... - Sahil Malik ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How do you read an XML schema in SQL 2005
    ... your database, simply create XML Schema Collections. ... Also I was given an XML file with this but it seems to be in a schema as ...
    (microsoft.public.sqlserver.xml)
  • XML Access and Word
    ... capabilities to populate a database. ... The XML schema was created by Access and Word seems to be reading it Ok. ... elements in my word document. ...
    (microsoft.public.word.vba.general)
Loading