(Roman B. Melnyk and Paul C. Zikopoulos) This article outlines result set retrieval from SQL data-change operations support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. Result set retrieval from data-change operations (INSERT, UPDATE, and DELETE) is supported in DB2 UDB
Other News
Serving HTML DB Reports
(Sergio Leunissen) Every organization needs to deliver reports on the Web. Often, slight variations of the same report need to be created for different end users. If you are a Web developer or a DBA who frequently needs to deliver reports and you want to make those reports more flexible or your
Implementing Triggers in SQL Server 2000
(Navneeth Diwaker Naik) Triggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the INSERT, DELETE and UPDATE triggering actions. There are two different types of triggers in Microsoft
SVG and Typography
(Fabio Arciniegas) Mixing the worlds of documents, programming, and visual design is a familiar experience for XML developers, especially when dealing with presentation technologies like SVG. Such mixtures can produce exciting new representations of information. They can also become ugly messes if o
Microsoft Releases Royalty-Free XML Reference Schema for Office Visio 2003
Microsoft has announced incorporation of the DataDiagramML XML Schema used by Microsoft Office Visio 2003 into the Microsoft Open and Royalty-Free Office 2003 XML reference schema program, announced in November 2003. Visio 2003 is a drawing and diagramming solution that helps users transform busi
Comparative Management Cost Study of Oracle Database 10g and Microsoft SQL Server 2000
Progressive Strategies has performed a Comparative Management Cost Study (CMCS) comparing Oracle Database 10g and Microsoft SQL Server 2000. This effort came about as a result of our review of the pre-release announcements from Oracle Corporation regarding the features and manageability benefits the
Transforming Visual Studio .NET Projects into NANT files using XSLT and .NET
(Michael Gold) I was looking for a solution on how to execute an XSL transform on a C# project file and convert it to a Nant build file. Nant provides the xsl file to do the conversion under the open source license agreement ( courtesy of Gordon Weakliem), but Nant does not provide away of producing
Indexed Views in SQL Server 2000
(Doug Carpenter) Views have been available throughout the history of Microsoft SQL Server. However, using views that return very large result sets can lead to poor performance, as the result set is not indexed and the entire result must be table scanned if the view is used in a join or a subquery of
Financial Reporting with Analysis Services
(Yoram Levin) You might think that financial reporting should be a straightforward implementation of the OLAP model. Almost every vendor that offers a product in the business intelligence (BI) arena touts financial reporting as one of the primary implementations of its tool. But if you’re going to u
dba3_Demo_Insert :: (Script Library)
Category: Reporting and Analytics for SQL Server Tags: sql reports, sql reporting, sq Compatibility: SQL Server 2000 and later Description: