Microsoft XML - XML standard for DML - Data Manipulation Language

Author

XML standard for DML - Data Manipulation Language

John A

2006-08-20, 6:35 pm

Hi all,

Hi all, is there a standard XML schema or DTD for representing SQL DML
statements, ie. SELECT, INSERT, UPDATE and DELTE? Doesn't Biz Talk use such
a language?

--
Thank you,
John

Kent Tegels

2006-08-20, 6:35 pm

Hello John,

> Hi all, is there a standard XML schema or DTD for representing SQL DML
> statements, ie. SELECT, INSERT, UPDATE and DELTE?

In general, no, not at least not yet. I believe that the intention of the
W3C is have DML semantics in XQuery 2.0. See [0] for more information.

> Doesn't Biz Talk
> use such a language?

I'm not sure about BizTalk, but SQL Server 2005 has extended its implementation
of XQuery with something called XML DML. See [1].

[0]: http://www.w3.org/TR/xqupdate/
[1]: http://msdn2.microsoft.com/en-us/library/ms177454.aspx

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/