Delete top rows from SQL Server Everywhere
Posted on 2006-10-26
I use a database table as a log. For simplicitys sake here's a scaled down version:
CREATE TABLE Log (
Date datetime NOT NULL PRIMARY KEY,
Title nvarchar(255) NOT NULL
Problem: I don't want the log to contain more than 11.000 items. When log goes over that, it should delete 1.000 rows from the top.
Question: How do I delete the first 1.000 rows (oldest entries) from this table in SQL Server Everywhere?
Limitations: SQL Server Everywhere does not suppport triggers, stored procedures, TOP n or SET ROWCOUNT.