the just inserted row.
> -----Original Message-----
> Posted At: Thursday, October 29, 1998 3:35 PM
> Posted To: programming
> Conversation: Getting IDENTITY value of a row that was just INSERTED
> Subject: Re: Getting IDENTITY value of a row that was just
> /* This is how I did it It probably is not the best way */
> Create Trigger TrigTI
> On T1
> For Insert
> From inserted
> INSERT INTO T2(MYIDT2)
> > How do I determine the IDENTITY value of a row that I just INSERTED
> > table? I want to put the identity of the row that was just inserted
> > row in a different table that I'll be inserting.
> > Note: the first table being inserted into has an auto-incrementing
> > property defined.
> > Thanks,
> > Russ Young
> > Bellevue WA