I have this trigger:
create TRIGGER Emp_log on Emp
Instead of insert as SELECT * FROM INSERTED
Then i make this insert:
insert into emp values(99,'bbb','aaa','99','1900-09-09',99,99)
As a result no line was inserted in the emp table, as it should be. But anyway i got the display of the inserted row with the command SELECT * FROM INSERTED.
The question is: The "INSERTED" table contains what is written in the insert statement, or contains rows actually inserted?
Because I expected no insert, and then no display from SELECT * FROM INSERTED.