For the integration of data there are many techniques of using SQLXML and .net the sql client data provider supports execute xml reader it can consume directly the result of it to do the xml query the user can use xml directly, the role of XML query in reinventing the wheel is very large the overlap between the xquery and xslt is too great for W3C to recommend both as separate languages if the XSLT is not considered enough as an XML query language then its development should be built from the same and semantic syntactic base as XSLTThe most
The XSLT and XQuery standards were created by different working groups within W3C. The both share the same data model, type system and function library, and both include Xpath 2.0 as a sub language. XQuery was initially created as a query language that would work with large collections of XML documents; it can also work with individual documents. So, its capabilities overlap with XSLT, which was designed to allow input XML documents to be transformed into XML or other formats.
Anyway, there are great differences between these
Debates on the XML-DEV and XSL mailing lists over the last two weeks concern the futures of XSLT, XPath, and, the latest addition to the W3C XML toolkit, XML Query. There are no signs of these debates ending this week. Discussion on XML-DEV about the design of XML Query rages on.
Reinventing the Wheel
The focus of last week's XML-Deviant was the concern expressed by several XML-DEV contributors that the interdependence of several W3C specifications may have exceeded the dictates of software reuse and become instead a tangled mess. Suggestions were
On Jan. 23, 2007 the W3C granted Recommendation status to XQuery, the XML query language designed to do for Web services what SQL did for relational databases. XQuery allows you to work in one common model no matter what type of data you're working with -- relational, XML or object data. It's used for queries that must represent results as XML, to query XML stored inside or outside the database, or to span relational and XML sources.
SQL/XML is another standard that uses declarative, portable queries to return XML by querying relational data. It's an
RSS/XML