SQL Server Get the current identity value of the table

Zany Zebra answered on September 6, 2020 Popularity 6/10 Helpfulness 10/10

related how to get table current identity value in sql server

related get current identity value sql server

Comment

SELECT IDENT_CURRENT('table_name')

Popularity 6/10 Helpfulness 10/10 Language sql

Tags: get identity sql sql-server value-of

Link to this answer
Share Copy Link

Contributed on Feb 20 2022

Zany Zebra

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT IDENT_CURRENT('Pets') AS Result;

Popularity 8/10 Helpfulness 7/10 Language sql

Source: database.guide

Tags: sql identity sql-server get

Link to this answer
Share Copy Link

Contributed on Sep 06 2020

Hilarious Hamerkop

0 Answers Avg Quality 2/10

Comment

SELECT RowId= IDENT_CURRENT('Settings.LITBL_ClusterGroup')

Popularity 3/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: get sql identity sql-server

Link to this answer
Share Copy Link

Contributed on Jan 24 2023

Famous Fish

0 Answers Avg Quality 2/10