Question for Trigger
I'm new at triggers and I have to create one.
The scenario is:
There is one table T1 and it has its primary key as ID which is autogenerated by Identity. I want a trigger Insert, it should fire, once I do the insert on T1, it should also insert some columns to T2. I also need tht identity column value. How should I do this?
Thanks for all your help.