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
>>
>>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.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people