Re: Time Zone in xsd:date

As a workaround you can always store your XML documents as untyped XML or modify
your schema to use a string type for those elements and/or attributes where
you're expecting a date value.

What solution to use depends on the type of queries you plan on running against
your data.

Denis Ruckebusch
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A68BF05D-FE37-4CD4-A3CC-2BF72EE10273@xxxxxxxxxxxxxxxx
Hi Kent,

"> Just one of the many oddities in SQL Server 2005's XSD engine. :)"

Thanks for the response. I can understand SQL Server's datetime data type
issue but my hang-up is receiving an XML date data type from non-Microsoft
sites using a nationally defined XSD. I was hoping to be able to use the
schema collection feature to validate incoming data. If that's not possible
then it's back to the drawing board for me.

Chris Macleod



.

Relevant Pages

  • Re: Best Practice for SQL2005 CRUD of RSS
    ... I'm only in favor of using the XML Data type if your ... That means that you are going to query it ... created but I may still need a schema when? ...
    (microsoft.public.sqlserver.xml)
  • Re: Biztalk schemas
    ... You'd rather ALWAYS use the string type. ... Do not use Xml for type transformation, ... Microsoft Certified Technology Specialist: BizTalk Server 2006 ... i need a schema which can accept null and date values. ...
    (microsoft.public.biztalk.general)
  • Re: deserializing and XML file [.csdl file EntityFramework]
    ... The data type that you are trying to serialize into -- it has a ... different namespace declared for the 'Schema' element than what is ... declared in your XML itself. ...
    (microsoft.public.dotnet.languages.csharp)
  • Exporting XML-Data types of field.
    ... When I export a test table to XML with the schema and use Word to use the ... I get errors about data type "Must be whole number" and "Must be in ... the correct format". ...
    (microsoft.public.access.externaldata)
  • Re: how to return xml document from a web service
    ... what specific XML you expect. ... If you have a schema that defines what you expect, ... The second issue with this approach is that XML is not a string. ... >> methods from the wire transport. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
Loading