>>

>>CREATE TRIGGER InsertPublication
>>ON Publications
>>AFTER INSERT
>>AS
>>BEGIN
>>UPDATE Books
>>SET NumPublications = NumPublications + 1
>>FROM Books, inserted
>>WHERE Books.ISBN = inserted.ISBN
>>END
>>

>>
>>I found this and other similar examples through a Google search. In each one there is a reference to "inserted". Is this a table?
>>What is "inserted"?
>>
>>Thanks
>
>The inserted and deleted tables are special tables available in Triggers. In SQL Server 2005 and up you can also access them using OUTPUT clause http://weblogs.sqlteam.com/mladenp/archive/2006/06/08/10122.aspx.
>
>In DELETE command Deleted table would contain record(s) that was(were) deleted
>
>In UPDATE Deleted would contain original values (before the update) and Inserted would contain new values
>
>In Insert Inserted will contain just inserted records.


Ahh, I see. Thanks!