how to find maximum identity number in a table ?

Question Posted / subash

Answers were Sorted based on User's Feedback

how to find maximum identity number in a table ?..

Answer / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

33 Yes

5 No

how to find maximum identity number in a table ?..

Answer / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

13 Yes

0 No

More SQL Server Interview Questions

Where is my database stored on the hard disk in ms sql server?

What is the recovery model?

What are examples of triggers?

explain different types of jions with examples briefly?

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

What is the need for indexing?

What are pages and extents? : SQL Server Architecture

What are statistics?

What are the authentication modes in sql server? How can it be changed?

How would we use distinct statement? What is its use?

What is log in sql server?

What are the rules to use the rowguidcol property to define a globally unique identifier column?

For more SQL Server Interview Questions Click Here