Is it possible, using a trigger, to update a data row before commiting the insert to a table by first updating the row in the INSERTED table ?

cengland0 (1/10/2011)

---

Got this one wrong because I didn't understand the wording of the question.


What row in the Inserted table? It didn't specify the one that was just inserted. Also, what kind of trigger? Can't you use an update trigger that would update a row before any inserts?

DML triggers use the deleted and inserted logical (conceptual) tables. They are structurally similar to the table on which the trigger is defined, that is, the table on which the user action is tried. The deleted and inserted tables hold the old values or new values of the rows that may be changed by the user action

Koen (da-zero) (1/10/2011)

---

What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a trigger that can do this. That's the whole point of the question.

cengland0 (1/10/2011)

---

I understand that you cannot update data in the TEMPORARY INSERTED table. I thought that question asked about Updating any row in the table was that that you inserted the record in -- not the temporary one. I was confused on the definition of "INSERTED table" thinking that could mean the table you just inserted the record in. Understand the issue now?

Koen (da-zero) (1/10/2011)

---

I surely understand the issue. I had to read the question a few times in order to get it right.
The thing that finally made the trick for me was that INSERTED was in upper case, so I thought it had to be the special temp table.

CREATE TRIGGER T1 ON Table1
INSTEAD OF INSERT
AS
BEGIN
   INSERT Table1(columns)
   SELECT
   some values, some with formulae
   FROM 
   INSERTED
END