belle’s sql musings

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

Posted in SQLXML, T-SQL Tips and Tricks by belle on October 13, 2008

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:

Tagged with: ,

One Response

Subscribe to comments with RSS.

  1. Matthew said, on October 15, 2008 at 4:04 am

    thank u r information

    it very useful

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

%d bloggers like this: