Set Limit for a Table Rows In SQL

sql, sql-server, sql-server-2008, sql-server-2008-r2

Solution

Create an `AFTER INSERT` trigger on the table. Here's something that would be relatively effective with your requirement:

create trigger LimitTable
on YourTableToLimit
after insert
as
    declare @tableCount int
    select @tableCount = Count(*)
    from YourTableToLimit

    if @tableCount > 50
    begin
        rollback
    end
go

Problem

I want to set the limit for my table's rows. How can I do it? For example 50 rows in my table.

Original source