>Back to my example. I'm not entirely sure what this trigger is doing.
>
>
>CREATE TRIGGER InsertPublication
>ON Publications
>AFTER INSERT
>AS
>BEGIN
> UPDATE Books
> SET NumPublications = NumPublications + 1
> FROM Books, inserted
> WHERE Books.ISBN = inserted.ISBN
>END
>
>
It just increase value in NumPublications field in Books table for these books that have new publications.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.