Valid SQLXML XSD Data Types, and Sample SQL Server XML Schemas

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

xsd:int or xsd:integer

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

    <Author AuthorID="1" FirstName="John" LastName="Doe"
            DateJoined="1992-05-01Z" DateTimeJoined="1992-05-01T00:00:00Z"/>

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

Microsoft also provided a list of schemas in It includes the following AdventureWorks sample schemas:

One comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s