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

Mention the 3 ways to get a count of the number of records in a table.

What is self contained scalar sub query?

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

how to find the second salary?

How will you add a dimension to cube? : sql server analysis services, ssas

How to copy the tables, schema and views from one sql server to another?

What does executeupdate return?

Why we need to use secondry database file? though, we can do same work using primary database file also.

What do you mean by the term 'normalization'?

what is lazy writer?

what is procedure in sql?

How do you clear a log file?

For more SQL Server Interview Questions Click Here