how to find maximum identity number in a table ?

Answer Posted / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What objects does the fn_my_permissions function reports on? : sql server security

747


What is a synonym for manipulation?

724


how to use DTS package in 2000,2005,2008 in sql server

1612


How to insert data into an existing table?

715


What is a transactions?

778






How to recreate an existing index in ms sql server?

711


What is auditing in sql server?

685


What is row-level compre?

713


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2373


How can I create a new template for import ? : sql server management studio

791


What is stored in the mssqlsystemresource database? : sql server database administration

777


what kind of lan types do you know? : Sql server database administration

702


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

858


What is a linked server in sql server?

760


How to create database with physical files specified in ms sql server?

722