--MySQL
INSERT INTO my_table( seq_field, val_field )
VALUES (NULL, 'Some Value');
SELECT LAST_INSERT_ID();

-- SQL Server
INSERT INTO my_table( val_field )
VALUES ( 'Some Value' );
SELECT SCOPE_IDENTITY();