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.

hi there...
this is for SQL server?

HTH

Gonzalo

If U r using SQL Server then....
You can Get all the information about the record just inserted from INSERTED Table, This is a Temporary System Table used to hold the row for Last insertion and can be queried as u do with user created table, It has the structure of the table u r inserting row in.

If U r using ORACLE Db then....
There two bind variables 1- :new and 2- :old
both holds new & old values respectively.

U can use these variables as...
:new.<columnName>
:old.<columnName>


Akhil