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

What happens if the update subquery returns multiple rows in ms sql server?

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

How do I uninstall sql server 2014?

What is SubQuery in SQL Server 2008

how can you attach more than 20 ldf files in sql server

check, not null,unique

What are the main differences between #temp tables and @table variables and which one is preferred?

What is field in algebra?

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

What is the difference between distinct clause and group by clause?

What is the purpose of sql profiler in sql server?

What is an indexing strategy?

For more SQL Server Interview Questions Click Here