c# - TRIGGER show two row affected T-SQL -

i data once. how it? example first action

table

mytable1 ( name, surname, username,  userdate ) 

first action mytable1

insert mytable1  select name, surname mytable2 

second action mytable1

create trigger example on mytable1 after insert update    mytable1 set       username = 'sysuser1212' , userdate = '2004-09-02 00:00:00.000' 

i 2 row affected mytable3 once

create trigger example2 on mytable1 insert update delete         insert mytable3     select name, surname, username, userdate     inserted 

create instead of trigger instead.

inside replace username 'sysuser1212' , userdate '2004-09-02 00:00:00.000' while doing insertion.

create trigger examplex on mytable1 instead of insert insert    mytable1 (username, userdate, name, surname) select     'sysuser1212'     , '2004-09-02 00:00:00.000'     , name     , surname inserted      -- following disapear /* create trigger example on mytable1 after insert update    mytable1 set       username = 'sysuser1212' , userdate = '2004-09-02 00:00:00.000' --*/