确保SQL Server中的数据完整性

publication list

我有一个可行的解决方案:

CREATE TRIGGER TransTerms_EnsureCon ON TransTerms
FOR INSERT, UPDATE, DELETE AS
BEGIN   
    IF (EXISTS (SELECT * 
                FROM TransTerms pT
                    INNER JOIN TransTerms nT
                        ON pT.TransId= nT.OfferLettingId
                        AND nT.TransTermId = pT.TransTermId + 1
                WHERE nT.StartDate != DATEADD(d, 1, pT.EndDate)
                    AND pT.EndDate > pT.StartDate
                    AND nT.EndDate > nT.StartDate
                )
    )

    RAISERROR('Transaction violates sequenced CONSTRAINT', 1, 2)
        ROLLBACK TRANSACTION
END

P.S.非常感谢瓦伦伯恩!