(Bob Swart) This article demonstrates how to build a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.
Other News
Set Operations
(Sanjay Mishra and Alan Beaulieu) There are situations when we need to combine the results from two or more SELECTstatements. SQL enables us to handle these requirements by using set operations. The result of each SELECT statement can be treated as a set, and SQL set operations can be applied on th
How To Merge Data from Two XML Documents Using System.Xml by Using Visual C# .NET
This step-by-step article shows you how to use a DataSet object to merge two XML documents. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident representation of data that provides a consistent, relational programming mo
Browser Boom
(Edd Dumbill) Conversation in the XML world is never far away from standards. After all, it was a standard that got us to where we are today. This week the focus is particularly on the renewal of innovation in the web browser and the associated problem of supporting a large legacy user base.
Building Global Internet Applications with the Oracle Globalization Development Kit
The Internet, by nature is called the World-Wide-Web because it addresses a global market. Internet applications have the infrastructure and capability to support users with different language and cultural requirements. A truly global Internet application needs to support data exchange in a wid
MDX Essentials: Basic Set Functions: Subset Functions: The Subset() Function
(William Pearson) In this lesson, we will conclude our “triptych” of articles exposing set functions that deal specifically with subsets. As we have noted, each function returns a subset of a larger set, as part of its operation. We began the subset functions articles with an examination of the Head
Performance Optimizations for the XML Data Type
(Shankar Pal, Vasili Zolotov and Leo Giakoumakis) This paper covers several ideas, which are designed to improve query and data modification performance of the XML data type in the upcoming version of Microsoft SQL Server 2005.
BUG: The error message provides an incorrect table name when you use an ambiguous update statement in SQL Server
Inside a trigger, if there is an ambiguous update statement and the first table in the FROM section is the logical table INSERTED or DELETED, the resulting message 8154 has an incorrect tablename. In SQL Server 7.0, the resulting message 1032 has an incorrect tablename.
Base64 Decoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 2000 and later Description:
Base64 Encoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 2000 and later Description: