how to find maximum identity number in a table ?

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

Post New Answer

More SQL Server Interview Questions

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,


Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


Which institute is best for SQL Server 2005 Training?

6 Answers  


Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  






What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  


Define indexes?

0 Answers  


How to view existing indexes on an given table using sys.indexes?

0 Answers  


Introduction of rollup clause using sum and group by clause?

0 Answers  


What are the advantages of having an index on the sql server?

0 Answers  


What does indexation mean?

0 Answers  


Categories