When you perform a query on an Oracle database by using the ODBC CONVERT function, the Microsoft ODBC Driver for Oracle requests that the data be converted to DECIMAL for all ODBC integer types. DECIMAL is the default Oracle convert type. The following code is an example of this query: SELECT {fn
Author: SSWUG Research
Integrating Keyword Search into XML Query Processing
Daniela Florescu, Ioana Manolescu and Donald Kossmann) Due to the popularity of the XML data format, several query languages for XML have been proposed, specially devised to handle data whose structure is unknown, loose, or absent. While these languages are rich enough to allow for querying the cont
How to move Microsoft Provisioning Server (MPS) databases to a clustered virtual SQL Server 2000 named instance
This article describes how to migrate your Microsoft Provisioning Server (MPS) databases from a stand-alone Microsoft SQL Server 2000 instance to a clustered virtual SQL Server 2000 named instance.
Failover Clustering Functionality
(Adam Machanic) How does failover clustering work in SQL 2005? And how does it compare with the failure support in Oracle and DB2? (R)
DB2 routines administration
(Bernard Zver) This article describes my DB2 admistration routines. The DB2 routines are stored procedures, user-defined functions, and triggers. We have many SPs, UDFs, and triggers, so I have prepared an easy way to manage them. If you want to change create definitions for DB2 routines, you must r
Oracle/PLSQL: BEFORE INSERT Trigger
A BEFORE INSERT Trigger means that Oracle will fire this trigger before the INSERT operation is executed.
Retrieving Objects from SQL Server Using SQLXML and Serialization
(Gianluca Nuzzo) This article will describe how to design a data access layer for a set of entities. You’ll learn how to write an XSD schema and design two simple helper classes — one for reading an XML stream from SQL Server using SQLXML and another for deserializing the XML stream.
Integrating XML and Relational Database Technologies: A Position Paper
(Giovanni Guardalben and Shaku Atre) The XML markup language should be the lingua franca of data interchange, but its rate of acceptance has been limited by an underlying mismatch between XML and legacy relational databases. This, in turn, has created a need for mapping tools that can make it relat
Compliance to Regulations: A Data Warehousing Approach
(Vaibhav Shringarpure) Compliance mandates are getting increasingly complex. Global mergers and acquisitions as well as continuous new regulations make consistent compliance extremely difficult, costly and time-consuming. Non-compliance is unacceptable. It can lead to inappropriate financial acc
Using a Custom Base Class for your ASP.NET Page’s Code-Behind Classes
(Scott Mitchell) One of the many benefits of object-oriented programming is that it allows for reuse of logic. For example, classes can be created that contain a base level of functionality. These base classes can then be extended through inheritance to create new classes that encompass the function