how to get table current identity value in sql server
snippet in sql

how to get table current identity value in sql server

user8583

SELECT IDENT_CURRENT('Pets') AS Result;