SELECT IDENT_CURRENT('table

how to find maximum identity number in a table ?

Question Posted / karthikeyan

Answer Posted / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are different types of join?

1296

How to create a dml trigger using create trigger statements?

1014

What is reportserver and reportservertempdb ?

152

how many bits ip address consist of? : Sql server database administration

881

Why should you use or avoid select * statements?

1002

How to sort query output in descending order in ms sql server?

928

What is an example of a primary key?

957

What is difference between line feed ( ) and carriage return ( )?

880

How do I view a stored procedure in sql server?

970

What is subquery explain with example?

1042

Tell me what is the difference between locking and multi-versioning?

1006

How can you stop stored procedures from recompiling?

879

What is the purpose of sql profiler in sql server?

997

What is the filtered index?

1027

What is data source in connection string?

889