Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-31 : 19:37:25
|
Phil writes "we need to insert a record into a table which has autonumber on the customerID, we have no trouble inserting the data using INSERT INTO but we cannot get the customerID of the record that we have just inserted. We run a last record SQL after having inserted the data but it gives us the previous CustomerID. If we add 1 to this then select the record EOF/BOF is returned."
|
|
|
|
|
|
SQL - INSERT INTO