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

"Mike C#" <xyz@xxxxxxx> wrote in message
news:exr4x%23gYIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
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


Answered in microsoft.public.xml
Please do not post the same question independently to multiple groups.

--

Joe Fawcett (MVP - XML)

http://joe.fawcett.name


.

Relevant Pages

  • Re: XML column type "constraint"
    ... collection on an XML column. ... We're first altering the table to redefine ... Could it be faster by adding a new xml column with the schema collection ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Found operand of type xdt:anyAtomicType *. Why?!?!
    ... I insert the XML data into the table with success. ... If I insert the same XML in a table without schema collection I don't receive this error... ... PRINT 'Creating the xmlQueue table...' ...
    (microsoft.public.sqlserver.xml)
  • Re: XML Validation: Declaration not found for element
    ... CREATE XML SCHEMA COLLECTION acc as N' ... declare namespace d="http://t/transactionBlob/MainXMLSchema.xsd";; ...
    (microsoft.public.sqlserver.xml)
  • Re: Very Basic Question
    ... You can store XML without a schema collection. ... I am reading a book SQL express starter kit and has a chapter on XML in ...
    (microsoft.public.sqlserver.xml)
  • xml schema validation error while creating schema collection.
    ... I am trying to create a schema collection. ... XML Validation: XML instances of the content model of type or model group ...
    (microsoft.public.sqlserver.xml)
Loading