gouripatil23 (1/11/2008)
Hi!I want Update one table when in another table insert new record .I didn't understand how i get this new inserted ID.
Regards
Gouri
Hi Gouri,
In the trigger body you have access to two virtual tables, inserted and deleted. These contain the data about the rows that you have inserted (or deleted/modified). You can update the table you wish based on the inserted table. See http://msdn2.microsoft.com/en-us/library/ms189799.aspx
Regards,
Andras