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 is the difference between deallocate cursor and close cursor?

Write down the syntax and an example for create, rename and delete index?

Do you know data definition language, data control language and data manipulation language?

What are the type of Indexes? which one is best, why?

What is user-defined functions? What are the types of user-defined functions that can be created?

What is microsoft sql server?

What area unit the various kinds of info compression introduced in sql server 2008?

What is the order in which the sql query is executed?

What is sqlcmd?

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

How send email from database?.

What is the purpose of self join?

For more SQL Server Interview Questions Click Here