CODE EXAMPLE FOR SQL

SQL Server Get the current identity value of the table

SELECT IDENT_CURRENT('table_name')