(Sanjay Mishra and Alan Beaulieu) Whether you are querying, modifying, or deleting data, the WHERE clause is the mechanism for identifying what data you want to work with. This chapter explores the role of the WHERE clause in SQL statements, as well as the various options available when building a W
Other News
Using XPath Predicates (Sample Chapter)
(Steven Holzner) The following example uses the logical operator >. This rule applies to all <PLANET> elements after position 5: <xsl:template match="PLANET[position() > 5]"> <xsl:value-of select="."/> </xsl:template> There is also a true function that always returns a value of true,
Identifying Your New Records – Introduction
(Bruce Johnson) While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. The problem being that, when we add records to the database, there are many cases where we need to know the key of the reco
Calling Stored Procedures with ADO.NET
(Paul Kimmel) Because stored procedures are not written in Visual Basic .NET, VB.NET programmers have to learn stored procedure grammar and keywords and practice writing SQL to use them. In a perfect world, the division of labor in software development would be divided between a stored procedure pro
Business Intelligence with Microsoft SQL Server Reporting Services – Part 2
(Adnan Masood) Not all reports are static, most of the enterprise reports are data driven or parameterized. In the following section I’m adding two variables, startdate and enddate in the Orders Report. These arguments will be used to filter the data being queried from orders table.
Using Large Objects in .NET
(Jason Price) In this article, a sequel to a previous article on using database objects in .NET, you will learn how to use large objects in Visual Basic .NET (VB.NET) and Visual C# .NET (C#). Specifically, you will earn how to read and write to large objects (LOBs) using .NET. You will also lear
Stored Procedure class generator
(b_hardman) This is a small project to generate classes for accessing stored procedures via a webservice, born out of frustration with SQLXML 3.0
Move data using the IBM DB2 Migration Toolkit
(Paul Yip) Was your application recently ported to IBM DB2 Universal Database (UDB) on Linux, UNIX or Windows? Do you want to move data from an existing deployment of Oracle or SQL Server to DB2 UDB? Learn how to do this using the IBM DB2 Migration Toolkit.
Access federated data sources: Modeling OLAP cubes through the DB2 Information Integrator and DB2 Cube Views
(Martin Klumpp) Business intelligence regularly requires the integration of heterogeneous data from different sources (relational databases and non-relational sources like XML documents or spreadsheets). In this tutorial, you’ll first learn how to set up a federated database with heterogeneous d
Creating a PHP-Based Content Management System, Part 5
(Peter Zeidman) Welcome to the penultimate installment of the series. So far we’ve looked at the basics of database interaction using PHP, as well as some vital techniques such as validation and error handling. We’ve allowed anyone to be able to add or remove content at the touch of a button without