SELECT IDENT_CURRENT('table

how to find maximum identity number in a table ?

Question Posted / arvind rohit

Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

33 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How exceptions can be handled in sql server programming?

1074

How to execute multiple stored procedures at one time in sql server?

1059

How secure is sql server database?

1067

What is the minimum recommended amount of ram for sql server 2012 enterprise?

977

Explain few examples of RDBMS?

1101

Can we perform backup restore operation on tempdb?

1074

Do you know sql server 2008 introduces automatic auditing?

1050

What is the purpose of the tempdb database?

1045

What do you mean by a dependent functionality in a build?

1197

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1113

How to create new databases with "create database" statements?

1067

What are the database roles? : sql server security

1277

How is sql server used?

1013

What are cursors and when they are useful?

1150

What is data set in report?

147