(Abey George) In order to get the data in XML format you need to change the select statement. You can use the FOR XML clause of select statement. Format of FOR XML is given below.
Other News
Planned Improvements in MySQL 5.1
(Jon Stephens and Chad Russell) Looking even further ahead, we expect continued improvements in MySQL 5.1, with the possible addition of another major feature that so far hasn’t been implemented yet. This is the implementation of triggers. Triggers are almost certain to make an appearance in MySQL 5
DB2 Viper: Range Partitioning and Large RID support
DB2 Viper contains innovative features for delivering information on demand and scaling databases to new levels. The Table (Range) Partitioning capabilities in DB2 Viper provide a number of advantages including better query performance, improved large table manageability, and dynamic data roll-in/ro
SQL Server 2005 Programmability Enhancements — Common Table Expressions
(Scott Klein) There is a plethora of new T-SQL features and enhancements in SQL Server 2005, and you could probably write a small book talking about all of them. However, this article will focus on one of them — specifically, Common Table Expressions (CTE), because personally they have come in handy
Legacy Systems – What Next? Consider Recycling
(Arik Kilman) Every Fortune 1,000 corporation has within its IT domain robust, mission-critical legacy applications. Deployed as far back as the 1970s and ’80s, they are often stable, reliable, fast, productive, efficient, and are the heart and soul of the enterprise. In many cases, legacy systems a
MySQL CEO Mickos: Beware of proprietary vendors’ giveaways
(Jan Stafford) Open source software developers offer freebies, and the reward they reap is input that spurs advances in their creations. When a proprietary vendor offers free software, however, there is usually a hook inside, says MySQL AB CEO Marten Mickos. So, he says, look carefully before you bi
Journaling at object creation on DB2 for iSeries
There is often a time gap between the time a file is created and the time some person or product turns on journaling protection for this newly-created object. In some environments, that time gap represents a risk: What if an application adds data to this new object before journal protection is ena
Fast and compact HTML/XML scanner/tokenizer
(c-smile) The proposed code is an implementation of an HTML and XML scanner (or tokenizer).
Technical insights into SQL Bundle 5 from the development team
(Andras Belokosztolszki, David Connell, Tom Harris and Richard Mitchell) Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team offer insight into some of the major new features, and the technical challenges they faced in implementing them.
Build a Query Processor Class for Networking in PHP 5
(Alejandro Gervasio) Welcome to the first of three tutorials in a series that covers network programming in PHP. In this article you will learn how to use some useful PHP networking functions that will help you perform a variety of common networking tasks. To that end, you will build a simple networ