sql server 2008 - Prevent table from adding more than a row -
in way of implementing configuration table, table suppose have 1 row @ time.
is there way in sql server 2008 prevent table adding more row?
any ideas?
add static, computed, column , make unique.
alter table mytable add uniquekey 1 persisted constraint uq_mytable_uniquekey unique if adds row, cause unique constraint violation
Comments
Post a Comment