Can anyone give me a quick example of how to retrieve a saved record in a table with an identity column, i.e., you default all identity columns to 0, you save a header record, but to save the related data you need to know the number of the just saved header record.
Any suggestion grateful.