get current identity value sql server

Famous Fish answered on September 6, 2020 Popularity 4/10 Helpfulness 1/10

answer get current identity value sql server

related SQL Server Get the current identity value of the table

related how to get table current identity value in sql server

Comment

SELECT RowId= IDENT_CURRENT('Settings.LITBL_ClusterGroup')

Popularity 4/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: get identity sql sql-server

Link to this answer
Share Copy Link

Contributed on Jan 24 2023

Famous Fish

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 value-of identity sql-server get

Link to this answer
Share Copy Link

Contributed on Feb 20 2022

Zany Zebra

0 Answers Avg Quality 2/10

Comment

SELECT IDENT_CURRENT('Pets') AS Result;

Popularity 8/10 Helpfulness 7/10 Language sql

Source: database.guide

Tags: identity get sql-server sql ident

Link to this answer
Share Copy Link

Contributed on Sep 06 2020

Hilarious Hamerkop

0 Answers Avg Quality 2/10