CREATE TRIGGER book_update ON BOOK FOR UPDATE
AS
IF @@ROWCOUNT=0 BEGIN
RASIERROR('没有任何列发生了变化!',16,10)
RETURN
END
IF UPDATE(aa)
UPDATE book SET aa='1' FROM inserted i WHERE book.PK=i.PK AND aa='0'
ELSE BEGIN
RASIERROR('aa列没有发生变化!',16,10)
RETURN
END
GO