SQLXML

1 of 568 | Making XQuery Control Structures Work for You - The XQuery language is the XML analogue of SQL, designed to augment XPath 2.0 by working with sets of values, not just with single scalar values....

2 of 568 | The W3C XQuery working group has posted a new candidate recommendation of XQuery Update Facility. - The W3C XQuery working group has posted a new candidate recommendation of XQuery Update Facility. XQuery as it currently exists is basically just SELECT in SQL terms. XQuery Update adds INSERT, UPDATE, and DELETE. More specifically it is: More......

3 of 568 | W3C Invites Implementations of XQuery Update Facility 1.0 (Candidate Recommendation) - 2008-08-07: The XML Query Working Group has published the Candidate Recommendation of XQuery Update Facility 1.0. This document defines an update facility that extends the XML Query language, XQuery. The XQuery Update Facility provides expressions that can be used to make persistent changes to instances of the XQuery 1.0 and XPath 2.0 Data Model. This document incorporates changes made against the Candidate Recommendation of 14 March 2008. Learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

4 of 568 | 24 Jul 2008 - Cats and Dogs It's been the rainiest July on record here - and the month isn't over yet, of course. We discovered that the swimming pool can indeed fill above the top of its liner. And during the storms, the dog, who is possessed by a daemon, becomes uncontrollable. or controllable only with difficulty. I still miss being able to have time to concentrate, to focus enough to write reasonable amounts of code, to program. Working at W3C means I get to have a vague warm fuzzy feeling about helping the world a teeny bit, but it isn't always enough compensation. In what little spare time I have, I scan pictures from old books. Soemone recently made a set of phot......

5 of 568 | Map Dataset to XML and XML to Dataset - Relational databases to XML for Biztalk (maybe?) Found A good Article by Xun Ding Check it out below! Map DataSet to XML and back Map XML to Dataset and back Published: 10 Sep 2007 By: Xun Ding This article illustrates the translation to and from an ADO .NET DataSet and XML. Introduction Since the arrival of the Internet, people have become more and more dependent on it for daily operations. The Web's (as well as computing applications') insatiable appetite for data has grown even more intense. Most websites have seen the interplay of relational database and XML. Websites rely on relational databases for storing a vast amount of data and performing fast retrieval and manipula......

6 of 568 | The W3C XQuery working groups has published the first working drafts of XQuery 1.1 and XQuery 1.1 Use Cases. - The W3C XQuery working groups has published the first working drafts of XQuery 1.1 and XQuery 1.1 Use Cases. So far there are just two significant additions listed: More......

7 of 568 | Validating Schemas During Runtime - I recently came across an interesting scenario.  In my application, we are transforming multiple incoming messages to a a canonical format.  We then take the output and place it in the MessageBox for some other downstream subscriber to process.  The Mapper did the transformation and created the output, however, based on the processing that we were doing during the mapping we found that some of the output messages we created did not always get created so that they would pass validation against the canonical schema.  Since we were doing our processing without the use of an Orchestration we did not have the ability to call a pipeline component to do the validation. &......

8 of 568 | Grouping in XQuery - One of the really convenient features introduced in XSLT 2.0 is Grouping. It is a typical second-generation change in a programming language: Not essential for the language itself (grouping can be done by hand using techniques such as the Muenchian......

9 of 568 | First Drafts of XQuery 1.1 and XQuery 1.1 Published - 2008-07-15: The XML Query Working Group has published the First Public Working Drafts of XQuery 1.1 and XQuery 1.1 Use Cases. The former describes a query language called XQuery, which is designed to be broadly applicable across many types of XML data sources. This version of XQuery extends the version of the XQuery 1.0 Recommendation published on 23 January 2007; see the list of changes. The latter document describes usage scenarios that will impact the design of XQuery 1.1. Learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

10 of 568 | In Defense of XML - Jeff Atwood recently published two anti-XML rants in his blog entitled XML: The Angle Bracket Tax and Revisiting the XML Angle Bracket Tax. The source of his beef with XML and his recommendations to developers are excerpted below Everywhere I look, programmers and programming tools seem to have standardized on XML. Configuration files, build scripts, local data storage, code comments, project files, you name it -- if it's stored in a text file and needs to be retrieved and parsed, it's probably XML. I realize that we have to use something to represent reasonably human readable data stored in a text file, but XML sometimes feels an awful lot like using an enormous sledgehammer to drive ......

11 of 568 | Need help with XQuery expression with XMLBeans - Hi,<br>I have this XML document that i want to query using XQuery :<br><br><?xml version="1.0" encoding="UTF-8"?><br><parcautomobile ...

12 of 568 | Friday is the last day to submit late-breaking news for Balisage this August in Montreal. - Friday is the last day to submit late-breaking news for Balisage this August in Montreal. "Balisage is a peer-reviewed conference designed to meet the needs of markup theoreticians and practitioners who are pushing the boundaries of the field. It's all about the markup: how to create it; what it means; hierarchies and overlap; modeling; taxonomies; transformation; query, searching, and retrieval; presentation and accessibility; making systems that make markup dance (or dance faster to a different tune in a smaller space) — in short, changing the world and the web through the power of marked-up information. It's an XML Conference. It's an XSL Conference. It's a conference about XSD, XQuery, ......

13 of 568 | E4X and/or VB9 XML Users - How's it going? - I've been spending a lot of time with XML again lately. Since my last stint with XML, I know we shipped native XML suppport in VB9. I also know that there are E4X implementations out in the wild. What I'd love to know is how either of these are working out for people? What do you love? What blows? What do you wish you had? I'm also interested in hearing from XQuery users, but I'm keenly interested on how the “you got peanut butter in my chocolate” solutions are working out. Feel free to comment here or via a private mail (dbox at the usual place).  ...

14 of 568 | E4X and/or VB9 XML Users - How's it going? - I've been spending a lot of time with XML again lately. Since my last stint with XML, I know we shipped native XML suppport in VB9. I also know that there are E4X implementations out in the wild. What I'd love to know is how either of these are working out for people? What do you love? What blows? What do you wish you had? I'm also interested in hearing from XQuery users, but I'm keenly interested on how the “you got peanut butter in my chocolate” solutions are working out. Feel free to comment here or via a private mail (dbox at the usual place).  ...

15 of 568 | XQuery and Literate Programming - "One thing leads to another" might be the sub-title for the web. Last night I found myself by some circuitous route in LiteratePrograms, a wiki set up by Derrick Coetzee. The site incorporates a version of that earlier WEB. Donald......

16 of 568 | Michael Kay has released version 9.0.0.6 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0.0.6 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. More......

17 of 568 | XMLMind has released Qizx/db 2.1, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0. - XMLMind has released Qizx/db 2.1, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0. Version 2.1 adds support for XQuery Update. The query interpreter part is available under an open source license....

18 of 568 | XRX: A Simple, Elegant, Disruptive - XRX is a new web development architecture that is a milestone in elegant simplicity. XRX stands for: XForms on the client REST interfaces and XQuery on the server Because XRX uses a single model for data (XML) it avoids the......

19 of 568 | DataDirect Technologies Hosts XML and XQuery Workshops at Dali - Business Wire via MSN Money May 19 2008 8:15AM GMT...

20 of 568 | The W3C XQuery working group has posted the candidate recommendation of XQuery and XPath Full Text 1.0. - The W3C XQuery working group has posted the candidate recommendation of XQuery and XPath Full Text 1.0: More......

21 of 568 | W3C Invites Implementations of XQuery and XPath Full Text 1.0 (Candidate Recommendation); Requirements and Use Cases Drafts Available - 2008-05-16: The W3C XML Query Working Group and the W3C XSL Working Group jointly published today a Candidate Recommendation of XQuery and XPath Full Text 1.0. This document defines the syntax and formal semantics of XQuery and XPath Full Text 1.0 which is a language that extends XQuery 1.0 [XQuery 1.0: An XML Query Language] and XPath 2.0 [XML Path Language (XPath) 2.0] with full-text search capabilities. Implementors are encouraged to run the groups' test suite and report their results. The Groups also published Working Drafts of XQuery and XPath Full Text 1.0 Requirements and Use Cases. Learn more about the XML Activity. (Permalink)...

22 of 568 | SyncroSoft has released 9.2, $345 payware XML editor written in Java. - SyncroSoft has released 9.2, $345 payware XML editor written in Java. Oxygen supports XML, XSL, DTDs, XQuery, SVG, Relax NG, Schematron, and the W3C XML Schema Language. According to the announcement, "Version 9.2 introduces a new XML Author edition specially tuned for content authors providing a well designed interface for XML editing by keeping only the relevant authoring features. The major additions in Oxygen XML Editor 9.2 are related to the WYSIWYG-like editing support and in particular to the DITA support. The general visual editing improvements include displaying the resolved content in the editor and navigation through links. With the new DITA features that include a new DITA map ......

23 of 568 | SQLXML 4.0 Not Installed in SQL Server 2008 - Prior to SQL Server 2008, SQLXML 4.0 was released with SQL Server and was installed by all SQL Server editions, except in SQL Server Express. Beginning Starting with SQL Server 2008, the latest version of SQLXML is no longer included in SQL Server.   When SQL Server 2008 is generally available, the latest version of SQLXML will be SQLXML 4.0 SP1.  The URL for the site where you can install SQLXML 4.0 SP1 will be added to this blog entry, and to the SQL Server 2008 Books Online, when SQLXML 4.0 SP1 is available.   If an application that requires SQLXML 4.0 will run on a computer where SQLXML 4.0 is not installed, you will need to download and install SQLXML 4.0 SP1. &n......

24 of 568 | Under the Hood: Oracle Berkeley DB XML - XML Databases, coupled with the power of XQuery, offer a potentially paradigm-changing way of dealing with data. The Oracle Berkeley DB XML database provides a rich XQuery-based engine that can be manipulated via XQuery, opening up possibilities for any we developer....

25 of 568 | Zorba XQuery Processor: Something Tells Me You Need To Pay Attention To This - So I got a ping from William Candillon yesterday on IM, but I wasn't around so am just now getting in sync with him today. He and I had a discussion about a year or so back regarding a potential......

26 of 568 | Norm Walsh Leaves Sun? And Just Like That, *POOF*, - ... I'm wondering how in the hell some obscure "XQuery Content" company stole Norm Walsh away from Sun. Y'all know who Norm Walsh is, right? Anyone care to provide some insight? Is Mark Logic really *that* good? Mark Logic Makers......

27 of 568 | Michael Kay has released version 9.0.0.4 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0.0.4 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. "Although there's a steady stream of new bugs and fixes, I think they are largely problems that affect very few users, so unless you know you're affected by one of the bugs, there's no great urgency to upgrade to the latest maintenance build." More......

28 of 568 | The Modis Team has released Sedna 3.0, an open source native XML database for Windows and Linux written in C++ and Scheme and published under the Apache License 2.0. - The Modis Team has released Sedna 3.0, an open source native XML database for Windows and Linux written in C++ and Scheme and published under the Apache License 2.0. Sedna supports XQuery and its own declarative update language. This release fixes bugs and improves transaction support. More......

29 of 568 | Adding Meta Tags via Code - C# in ASP.NET - So here is a question why would you want to add your Meta Tags via code? Kinda silly right? Cause if you were a great developer you probably have a whole list of meta tags you have created for your portfolio of web sites right? Well if you are the developer who has those templates you most likely will stop reading here and think this mikedopp character is kinda wierd or is one of those "because you can" type people. I know I am adding much too much fluff to this whole entry and spending too much time with words so here is the code to add meta tags to your on load event of either your master pages or just to that web site that you need to get out the door tonight. private void AddMetaTa......

30 of 568 | XQuery Scripting Extension 1.0 and Use Cases; Comments on First Public Drafts Welcome - 2008-03-28: The XML Query Working Group has published two First Public Working Drafts: XQuery Scripting Extension 1.0 and XQuery Scripting Extension 1.0 Use Cases. The former defines an extension to XQuery 1.0 and XQuery Update Facility. Expressions can be evaluated in a specific order, with later expressions seeing the effects of the expressions that came before them. This specification introduces the concept of a block with local variable declarations, as well as several new kinds of expressions, including assignment, while, continue, break, and exit expressions. The latter specification includes the usage scenarios that motivate the changes in the former. Learn more about the Extensible ......

31 of 568 | XML Query (XQuery) 1.1 Use Cases - 2008-03-27: The XML Query Working Group has published the First Public Working Draft of XML Query (XQuery) 1.1 Use Cases. This document specifies usage scenarios for XML Query (XQuery) 1.1, to illustrate important applications for the query language. Each use case is focused on a specific application area, and contains a Document Type Definition (DTD) and example input data. Each use case specifies a set of queries that might be applied to the input data, and the expected results for each query. See changes from the previous draft and learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

32 of 568 | The W3C XQuery working group has posted the candidate recommendations of XQuery Update Facility, XQuery Update Facility Use Cases, and XQuery Update Facility 1.0 Requirements. - The W3C XQuery working group has posted the candidate recommendations of XQuery Update Facility, XQuery Update Facility Use Cases, and XQuery Update Facility 1.0 Requirements. XQuery as it currently exists is basically just SELECT in SQL terms. XQuery Update adds INSERT, UPDATE, and DELETE. More specifically it is: More......

33 of 568 | W3C Invites Implementations of XQuery Update Facility 1.0 (Candidate Recommendation) - 2008-03-14: The XML Query Working Group has published the Candidate Recommendation of XQuery Update Facility 1.0. This document defines an update facility that extends the XML Query language, XQuery. The XQuery Update Facility provides expressions that can be used to make persistent changes (including node insertion, deletion, modification, and creation) to instances of the XQuery 1.0 and XPath 2.0 Data Model. The Working Group also published today two additional documents that will become Working Group notes: XQuery Update Facility 1.0 Requirements and XQuery Update Facility 1.0 Use Cases. Learn more about the Extensible Markup Language (XML) Activity. (Permalink)...

34 of 568 | SQL Server Management Pack - I found this nugget of a tool today.  I haven't tried it out yet, but it sounds like one terrific tool. http://www.microsoft.com/downloads/details.aspx?FamilyID=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Data......

35 of 568 | XQuery Training Event - Dear ServerSide.COM Community,<br><br>DataDirect Technologies is hosting a free XQuery tutorial workshop in Chicago, Washington DC, Houston, as well ...

36 of 568 | XQuery Tutorial - Dear ServerSide.COM Community,<br><br>DataDirect Technologies is hosting a free XQuery tutorial workshop in Chicago, Washington DC, Houston, as well ...

37 of 568 | SQL XML Documentation - How to create and compile SQL XML Documentation comments....

38 of 568 | XML: Done like a well-cooked steak - This recent Slashdot post on “The Future of XML” made me think about Ted’s post on Java and doneness. Personally (not speaking for my employer) XML has achieved Patriot-esque doneness (ignoring last Sunday's disappointment with the Giants). The format and data model stabilized ages ago (at least internet-scale ages). The standardization effort went into the errata/sustained-engineering phase years ago. Most development platforms have moved beyond the W3C’s first (and hopefully last) attempt to define programmatic interfaces. XQuery seems firmly implanted as a promising technology of the future. More importantly, XML survived XSD. Like Java (and C for that mat......

39 of 568 | XML: Done like a well-cooked steak - This recent Slashdot post on “The Future of XML” made me think about Ted’s post on Java and doneness. Personally (not speaking for my employer) XML has achieved Patriot-esque doneness (ignoring last Sunday's disappointment with the Giants). The format and data model stabilized ages ago (at least internet-scale ages). The standardization effort went into the errata/sustained-engineering phase years ago. Most development platforms have moved beyond the W3C’s first (and hopefully last) attempt to define programmatic interfaces. XQuery seems firmly implanted as a promising technology of the future. More importantly, XML survived XSD. Like Java (and C for that mat......

40 of 568 | Michael Kay has released version 9.0.0.3 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. - Michael Kay has released version 9.0.0.3 of Saxon, his XSLT 2.0 and XQuery processor for Java and .NET. This is a bug fix release. This is a "Maintenance Release clearing all known bugs up to 18 Jan 2008." More......

41 of 568 | XMLMind has released Qizx/db 2.0, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0. - XMLMind has released Qizx/db 2.0, a $3200 closed source, embeddable native XML database engine written in Java that supports XQuery 1.0....

42 of 568 | XQJ Tutorial: Understanding the XQuery API for Java - The XQuery API for Java (<a href="http://www.xquery.com/tutorials/xqj_tutorial/">XQJ</a>), is currently under development through the Java Community ...

43 of 568 | The DBIS Group at University of Konstanz has released BaseX 4.0, an open source native XML database with a GUI frontend that supports most of XQuery 1.0 and some of XQuery Full-Text. - The DBIS Group at University of Konstanz has released BaseX 4.0, an open source native XML database with a GUI frontend that supports most of XQuery 1.0 and some of XQuery Full-Text. It seems to be written in java so one presumes its platform independent....

44 of 568 | On the last day of the year, IBM developerWorks has published my look back at 2007 in the world of XML: XML 2007 Year in review. - On the last day of the year, IBM developerWorks has published my look back at 2007 in the world of XML: XML 2007 Year in review. Between XQuery, Atom, OpenDoc, and OOXML, 2007 was actually probably the most exciting year we've had since the dot bomb. I think we're finally heading up the second bump of a classic double bump adoption curve....

45 of 568 | SQL Server Unattended Install Script - Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working finally!!!   ;the PIDKEY will show up in greyed out text boxes during a MANUAL Install... use this for the PIDKEY Parameter IF NECESSARY (probably not necessary) http://msdn2.microsoft.com/en-us/library/ms144259.aspx#pidkey;create a directory c:\binaries;create a directory c:\data;run the silent install from your install directory (here the d drive):  ;V:\>Setup.exe /settings C:/setup.ini /qb  ; /qn is quiet mode, no GUI is displayed.; /qb is quiet mode, basic GUI information is displayed, no user interaction is required. Use /qb ;check for install errors: C:\Program Files\Micr......

46 of 568 | Dynamically Getting Namespaces in an XML - I have a utility that process XML files, ideally, I would like to be able to feed XQueries into the application, the problem was, the xml files have namespaces. So far, all examples on how to use XQuery with XmlNamespaceManager requires hard coded namespace, that means I need to know the URI and the prefix. Well, I would like to be able to dynamically get the namespaces. I came up with this solution, this method will return an instance of XmlNamespaceManager with a specified XmlNameTable. Unfortunately, XPath 1.0 does not support default namespace, the default namespace will have 'default' prefix. using System.Xml; using System.Xml.XPath; /// <summary> /// Returns an instance o......

47 of 568 | Version 2.0 of XQilla, an open source XQuery 1.0 and XPath 2.0 library and command line utility written in C++, has been released. - Version 2.0 of XQilla, an open source XQuery 1.0 and XPath 2.0 library and command line utility written in C++, has been released. Xqilla is implemented on top of Xerces-C++ and derives from Pathan. Version 2.0 implements the DOM 3 XPath API, and conforms to the both the XQuery and XPath 2.0 recommendations. It is now published under an Apache 2.0 licence....

48 of 568 | Handy SQL Delimited string to XML - I came across this simple yet great way of translating a delimited string to XML using SQL 2005. http://www.sqlservercentral.com/articles/XML/61618/   /* Here is the string that we need to split */ DECLARE @str VARCHAR(100) SET @str = '0001,0002,0003,0004,0005' /* I am converting the string to an XML structure by inserting XML tags. */ DECLARE @x XML SET @x = '<i>' + REPLACE(@str, ',', '</i><i>') + '</i>' /* Now we can apply XQuery to return a resultset */ SELECT x.i.value('.', 'VARCHAR(4)') AS Item  FROM @x.nodes('//i') x(i) /* Item ---- 0001 0002 0003 0004 0005 (5 row(s) affected) */ _qacct="p-03-ZsKAm7O3lI";quantserve(); ...

49 of 568 | Wrap the Result of an XQuery Query into an XML Document - Wrapping the result of an XQuery query into an XML document is very useful if you're working with atomic values....

50 of 568 | ETH Zurich has posted MXQuery 0.4.1, an open source (Apache 2.0) XQuery engine written in Java. - ETH Zurich has posted MXQuery 0.4.1, an open source (Apache 2.0) XQuery engine written in Java. It supports XQuery 1.0 (though typeless), XQueryP, FORSEQ, and XQuery Update. Version 0.4.1 fixes bugs, adds more functions and operators, and can now pass about 95% of the test suite....