In a prior article we discussed how to use PostgreSQL user-defined functions to solve the recursive tree problem and return a concatenated string of the result. In this article we demonstrate how to return the value in a table instead of as a string.

Discusses what table and data-driven programming is and how it is used.

In this article we will define what a cross-tab query is and how to create one. We will provide examples for Microsoft SQL Server, Microsoft Access, PostGreSQL, and MySQL, Oracle

This upcoming year will prove to be an exciting one for database technology. Many database vendors are coming out with milestone versions of their DBMS systems.

This article covers the primary database systems we use and what each holds in store this year. While we can't cover all databases here, we'll cover the ones we are most familiar with. We will cover what their current state is and what their future direction is. We will focus our attention on MySQL, PostGreSQL, and SQL Server

In this article, we'll cover some more SQL tricks for accomplishing tasks such as getting the details of the newest record from a relational database.

There has been a lot of debates around when to use stored procedures vs. raw sql. Many purists are vehemently on one side of the fence or the other. Strangely people talk about views to a lesser extent. Stored functions and triggers are almost nonexistent in these debates. In this article we'll try to provide a non-biased outline of the benefits and pitfalls of each approach.

In this sql cheatsheet we will provide some common query questions asked and SQL solutions to these questions. Most of these examples are fairly standard ANSI-SQL so should work on most relational databases such as PostGreSQL, MySQL, Microsoft SQL Server, Oracle, Microsoft Access. Some examples involving subselects or complex joins may not work in most versions of MySQL and some versions of Microsoft Access

In a prior article we discussed how to use SQL Server's user-defined functions to solve the recursive tree problem. In the SQL version we solved the common who reports to who problem. In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions. We will use a different example.

In this article we contrast and compare two approaches for separating business logic from presentation logic using two of our favorite web development languages: The template approach commonly used in PHP and the Code-behind approach found in ASP.NET.

This article is dedicated in memory of Edgar F. Codd - Father of Modern Relational Database Theory. In this article we will delve into the history of databases - how it started, where the industry is now and what its potential achievements will be.

We describe what a web service is, how to call webservices in ASP.NET. We provide the Google Search web service as an example.

This article provides some general guidelines for building a good Application. These lessons are based on our personal experiences and observations. Note that many of these guidelines may contradict what "Experts" will tell you.

In this article we focus on using server-side tags in web programming. We compare three offerings and how they approach server tags.

In this article we will delve into the features of the PostgreSQL object-relational database environment and what makes it special. We will focus on features that make PostgreSQL different from most relational database management systems (RDBMS).

In our article Active Server Pages (ASP), Java Server Pages (JSP), Cold Fusion (CFM) - A comparative analysis., We neglected to include PHP. PHP is a language that has been around for a few years and that appears to be gaining quite a bit of popularity.

This is an accompaniment to the article

In this article we will demonstrate how to populate an excel spreadsheet with data from an Access database

In this article we demonstrate how to solve the classic "Who does an employee" report to problem using SQL Server 2000's new User-defined function feature

This article provides a brief SQL How-to on how to summarize data. Most of the examples we provide will be based on the ANSI-SQL 92 standard. Some examples will show features specific to SQL Server 7.

In this article we provide a comparison of 3 server side scripting technologies by detailing the main features of each. We end with a comparison chart that ranks each by ease of use, capability, and costs.