Rowcount

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]
FOR  INSERT
AS
while (select count(*) from HISTORY) > 100000
         
BEGIN
     
          SET rowcount 200

          delete HISTORY
          WHERE Date = (SELECT MIN(Date) FROM HISTORY)
         
          SET rowcount 0
     
 END



Thanks !





kukiyaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
SET ROWCOUNT X
makes that any SELECT  / DELETE / UPDATE statement will only work on the first X rows (given X>0).
If X=0, this restriction is unset.

Let's say you have a table with 100 rows, and you set rowcount 5. SELECT * FROM yourtable will return exactly 5 rows, DELETE Yourtable will delete 5 rows aso.

Your trigger (on the insert statement )does nothing else than delete 200 rows from the HISTORY table as long as there are more than 100000 rows in it, deleting the oldest dates first.

CHeers
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kukiyaAuthor Commented:
Thaks alot !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.