how to get table current identity value in sql server

Hilarious Hamerkop answered on September 6, 2020 Popularity 8/10 Helpfulness 7/10

related SQL Server Get the current identity value of the table

related get current identity value sql server

Comment

SELECT IDENT_CURRENT('Pets') AS Result;

Popularity 8/10 Helpfulness 7/10 Language sql

Source: database.guide

Tags: get identity sql sql-server

Link to this answer
Share Copy Link

Contributed on Sep 06 2020

Hilarious Hamerkop

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT IDENT_CURRENT('table_name')

Popularity 7/10 Helpfulness 10/10 Language sql

Tags: sql sql-server identity get value-of sq

Link to this answer
Share Copy Link

Contributed on Feb 20 2022

Zany Zebra

0 Answers Avg Quality 2/10

Comment

SELECT RowId= IDENT_CURRENT('Settings.LITBL_ClusterGroup')

Popularity 4/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: get sql sql-server identity

Link to this answer
Share Copy Link

Contributed on Jan 24 2023

Famous Fish

0 Answers Avg Quality 2/10