chevy
08-26-2005, 12:59 PM
This is what I would like to do:
Select customerID from(Insert into customers(a, b, c, d) VALUES('a', 'b', 'c', 'd'))
I want to get the customerID that was assigned to the newly inserted customer. If possible I would prefer to do this without executing a second query.
Any ideas?
Chevy
Select customerID from(Insert into customers(a, b, c, d) VALUES('a', 'b', 'c', 'd'))
I want to get the customerID that was assigned to the newly inserted customer. If possible I would prefer to do this without executing a second query.
Any ideas?
Chevy