How can one determine in an INSTEAD OF TRIGGER whether an UPDATE was called or an INSERT? Is there any other way than by looking at the INSERTED and DELETED tables? Kevin Goff mentioned looking at those two tables, but I am wondering if the DML language provides another way to determine this within the trigger?