Hi list peeps.... In many of my projects I have the need to insert a new record into a table and then later on in the script update this record, Right now I am doing this by doing the insert, then immediately doing a Select to return the latest id (unique id) which I store later for my update.
Is there any way I can do an insert and have it return the unique auto-assigned id? Cheers Dave
