If table has int column that is primary key identity with increment of 1 is this the best (fastest) way to get at what the key value is so I can do an update on it after creating it as a copy of another record, except for the key of course.

This is a web hit so I know no one else is adding records between my insert of this record and my update of it.

select top 1 id from T1 order by id desc

Thanks.