To retrieve the identitty of the last record created I used to use
sSQL = "SELECT @@IDENTITY AS NewID"
iNewID = oCon.execute(sSQL)("NewID")
But it has too many problem so I switched to
sSQL = "SELECT IDENT_CURRENT('fit_bookings') AS NewID"
iNewID = oCon.execute(sSQL)("NewID")
And it seems to work fine. I have also seen
SCOPE_IDENTITY()
But have never used it. There is another introduced in SQL 2005 (Output?) but havent read anything of it as yet.
Back