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 » Transact SQL » Database Progra... » Business rules   (RSS)
  • 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