I really need some help on how to create triggers in MS SQL.
Previously we are using MySQL and now we need to migrate to MS SQL.
Can some one teach me on how to create triggers in MSSQL?
I have a made a trigger that do this
TableA and Table B.
If I insert Name and Age to Table A it automatically creates a copy to Table B.
I have use this syntax.
create trigger tig1 on TableA
for insert as
insert into TableB(name2,age2) select name,age
Now next thing that I want to do is when you update the Name or Age in TableA it will also update in TableB.
I will really appriciate any of your help.