#MySQL/InnoDB
SELECT LAST_INSERT_ID()
#MySQL/MyISAM
SELECT LAST_INSERT_ID()
#Sybase
SELECT @@Identity
#Oracle
SELECT arve_seq.currval FROM DUAL
#Microsoft SQL Server
SELECT @@Identity