Subject | limit rows in a table |
---|---|
Author | newgen_315 |
Post date | 2005-08-25T14:54:47Z |
Hi all,
Could someone please suggest how I can limit the amount of rows a
user
can enter in a table, using a Stored Procedure or a trigger.
I would like to limit the amount of rows to 1K, and all new inserts
would be stopped/cancelled from this point on.
How should I accomplish this?
Thanks
Daniel
Could someone please suggest how I can limit the amount of rows a
user
can enter in a table, using a Stored Procedure or a trigger.
I would like to limit the amount of rows to 1K, and all new inserts
would be stopped/cancelled from this point on.
How should I accomplish this?
Thanks
Daniel