How to return the last identity value generated for a specified table?

Returning the last identity value generated for a specified table:

Following example returns the last identity value generated for the Person.Address table in the AdventureWorks2012 database.

USE AdventureWorks2012;
GO
SELECT IDENT_CURRENT ('Person.Address') AS Current_Identity;
GO

OR

Following example returns the last identity value generated for the College:

USE College;
GO
SELECT IDENT_CURRENT ('Student') AS Current_Identity;
GO

• Tweet
• Share
• Share
• Share
• Share

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Related Post

• SQL_VARIANT_PROPERTY FunctionSQL_VARIANT_PROPERTY (Transact-SQL)This functions returns the base data type and other information
• Return data part from SQL Server datetime(Current) datatypeIn SQL Server there is following queries are as follows to get date part only from a SQL Serve
• Find list of all the jobs currently running on serverGet a list of SQL Server Agent Jobs--On each server, you can query the sysjobs table in the msdb.&n
• SQL Basic- Introduction   Introduction            Structured Query Langu