ionutdinulescu
Programmer
I have an sql server table with an autonumbered field as primary key.
I insert a record into the table and then I want to get the id of the new record.
For this i use Select max(id) from myTable
This works fine, but I don't think it will work properly in a multi user environment.
Do you have any other suggestions ?
I insert a record into the table and then I want to get the id of the new record.
For this i use Select max(id) from myTable
This works fine, but I don't think it will work properly in a multi user environment.
Do you have any other suggestions ?