Here is a partial list of valid XSD data types for SQL Server 2005:

Note that in SQL Server 2005, the timezone needs to be included in the date or dateTime element or attribute value, for example:

<Authors>

    <Author AuthorID="1" FirstName="John" LastName="Doe" 

            IsIndependent="true" 

            DateJoined="1992-05-01Z" DateTimeJoined="1992-05-01T00:00:00Z"/>

</Authors>

Note the existence of the letter Z at the end of the date and datetime attributes.

Microsoft also provided a list of schemas in http://schemas.microsoft.com/sqlserver/. It includes the following AdventureWorks sample schemas:

• AdventureWorks Customer Contact Information Schema
• AdventureWorks Customer Contact Record Schema
• AdventureWorks Customer Contact Type Schema
• AdventureWorks Consumer Demographics Survey Schema
• AdventureWorks Product Catalog Schema
• AdventureWorks Manufacturing Instructions Document Schema
• AdventureWorks Product Warranty and Maintenance Information Schema
• AdventureWorks Standard Resume Schema
• AdventureWorks Retail Stores Demographics Survey Schema

Be Sociable, Share!

• 
• 

Related posts:

1. Free Database Schemas …
2. SQLXML : How to List Columns That Have the XML Data Type …
3. SSRS Error: configuration file contains an element that is not valid …
4. Generating Random Data for SQL Server and MySQL …
5. SQLXML : How to Alter Existing Column Schema (XSD) …
6. SQLXML : How to Work With XML Elements (or Nodes) in SQL Server …