I need to get the next available record number from my table. Ussing a 'BEGIN TRANSACTION' and only 'END TRANSACTION' at end. Multilple inserts will take place and for every insert I need to know the record number(auto increment column in my table) to add records to a detail table (link on the record number of the header table).

Must perform the same function as the @@identity in a MS SQL server database.