how to find the next identity value in sql server code example Example: how to get table current identity value in sql server SELECT IDENT_CURRENT('Pets') AS Result;