Here is a partial list of valid XSD data types for SQL Server 2005:
| xsd:int or xsd:integer |
| xsd:decimal |
| xsd:date |
| xsd:dateTime |
| xsd:string |
| xsd:base64Binary |
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
Related posts:
- Free Database Schemas ...
- SQLXML : How to List Columns That Have the XML Data Type ...
- Generating Random Data for SQL Server and MySQL ...
- SSRS Error: configuration file contains an element that is not valid ...
- SQL Server Spatial Data for Canada ...
- SQLXML : How to Work With XML Elements (or Nodes) in SQL Server ...
Filed under:
SQLXML, T-SQL Tips and Tricks
thank u r information
it very useful