Posted on 2001-06-12
I would like to know what Rowcount means.
I'm using the following code as a trigger to always keep the table records as 100,000.
I dont understant the "Set Rowcount 200 " at the begining.
And why do I have to sero it at the end.
CREATE TRIGGER [TRG_CLESR_HISTORY] ON [HISTORY]
while (select count(*) from HISTORY) > 100000
SET rowcount 200
WHERE Date = (SELECT MIN(Date) FROM HISTORY)
SET rowcount 0