I have an Ms SQL table
ID (Counter, auto-increment) (UNIQUE)
Field1 varchar(50) (NOT UNIQUE)
In my java code, I run a statement like
executeUpdate("INSERT INTO Table1...").
I want to be abble to retreive the value "ID" if the counter
just created in SQL. What's the BEST way? (no Requery and MoveLast please...)