After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).
WITH OrderedOrders AS
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
WHERE RowNumber BETWEEN 50 AND 60;
It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER … Read morePaging records in MS SQL Server 2005
Ingredients for our web application are Apache HTTP Server 2.2, PHP 5.2, Firebird 2.1and Oracle 10g Express Edition. Like in any IT project, not everything goes according to plan and there are so many pitfalls; some of which are: Repositories Linux Firewall SE Linux Permissions Using the package manager (Yum) to add, remove and upgrade … Read moreSetting up a web application on CentOS 5.3
Firebird SQL Server has always been a “proper” database system since it forked from Borland’s famous Interbase. I just love it! In some big database applications, I found that the developers preferred to duplicate a set of tables for probably performance reasons. For example, in most accounting databases, there is a notion of company so … Read moreFirebird SQL: The Power of Simplicity