THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » Transact SQL » Business rules » Database Programming   (RSS)
Sorry, but there are no more tags available to filter with.
  • Using ROWVERSION to enforce business rules

    Suppose that you need to enforce the following business rule: contracts cannot be changed after you have started working on them (let us assume that that particular business operates in the perfect world).  You can use a ROWVERSION column, a persisted computed one, and a foreign key constraint to implement this rule, and I ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on April 28, 2009
Privacy Statement