xsd:dateTime and sqltypes:datetime validations differ. Any idea why? Please help.
Tue, 11 Dec 2007 17:21:26 -0500
According to
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=167649
dates(datetimes) need to have Z specified when schema validation is desired.
Using xsd:dateTime, it works.
Why no matter what I try, I cna't make SQL smalldatetime or datetime derivaties to work?
...
|
[Announce] Stylus Studio 2008 Now Available
Tue, 11 Dec 2007 10:04:04 -0800 (PST)
[Announce] Dear microsoft.public.sqlserver.xml,
Stylus Studio 2008 is now available for online purchase or free trial
download at: http://www.stylusstudio.com/xml_download.html
The new release adds new XQuery & Web Services tools, support for
MySQL, PostgreSQL, HL7 EDI, and Microsoft .NET Code Generation and ...
|
GML Support in 2008
Sun, 9 Dec 2007 16:11:30 -0500
BOL for SQL Server 2008 says that the geometry and geography data types
support a subset of GML functionality. Does anyone know if MS has a
shortened version of the GML XML Schema available that reflects the features
that are actually implemented in 2008?
Thanks
...
|
Trying to query relational data from XML
Fri, 7 Dec 2007 11:44:12 -0500
I've been trying to return a regular result set from an XML typed field.
I've managed to do it with OpenXML within a stored proc, but it won't work
inside a UDF (calling sp_xml_preparedocument is not allowed inside a UDF).
So I turned to xquery.value, but I can't find any simple examples on how to
return mu ...
|
Free Prescription Assistance
Thu, 6 Dec 2007 14:44:55 -0800 (PST)
Great site for prescription assistance is presented at
http://www.freediscountprescriptioncards.com . ...
|
OPENXML problem with xmlns:xsd
Thu, 6 Dec 2007 14:17:05 -0800 (PST)
The following works fine and gives expected result:
DECLARE @doc varchar(8000)
SET @doc ='
<ScheduleDefinition>
<WeeklyRecurrence >
<WeeksInterval>1</WeeksInterval>
<DaysOfWeek>
<Tuesday>true</Tuesday>
</DaysOfWeek>
</WeeklyRecurrence>
</ScheduleDefinition>
'
--Create an internal representat ...
|
Re: Question about schema collection
Thu, 6 Dec 2007 17:34:20 +0000 (UTC)
You are trying to have your cake and eat it too.
If you want to represent a null value, you have two choices: represent it
by an element marked as nil (which is what I do, nice and explicit) OR omit
the element for the document (which is what SQL Server normally does).
What you have in your example of vSm ...
|
|
|
How to replace the SQLXML ISAPI functionality on w2k3/sql2005
Wed, 5 Dec 2007 04:03:00 -0800
Hi
I am tasked with migrating an old system from W200/SQL2000 to w2k3/SQL2005.
Th eoldsystem made use of SQLXML Isapi Virtual Directories to deliver XML to
clients. I have discovered that the ISAPI extension is deprecated. How do I
get the same functionality on the new platform? I guess I need a dotNET
progr ...
|
xmlbulkload complex elements and attributes
Tue, 4 Dec 2007 11:38:00 -0800
I am using MSSQL2k and sqlxmlbulkload 3.0. All of the elements in my XML have
attribues, when I Execute each element's attribute values are inserted into
seperate rows rather than one continus row. I assumed that since there is a
containing element that the sub elements attributes would be in one record
Her ...
|
Question about schema collection
Tue, 4 Dec 2007 01:35:03 -0800
Hi,
I've created a schema collection with the following statement:
/****** Object: XmlSchemaCollection [dbo].[IncVarTypeTestCollection]
Script Date: 12/04/2007 09:01:56 ******/
CREATE XML SCHEMA COLLECTION [dbo].[IncVarTypeTestCollection] AS N'
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
...
|
