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

How can delete duplicate records in cte in sql server?

964

Write a program to fetch first 10 records from a file?

1003

Can primary key be null?

926

What is the architecture of ms sql reporting service?

985

role of sql sever 2005 in database rather than any other database

1934

How exceptions can be handled in sql server programming?

1012

How many types of attribute relationships are there? : sql server analysis services, ssas

1070

What is the difference between clustered and a non-clustered index?

1019

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

978

What are different types of statements that are supported by sql?

1041

Why de-normalization required?

995

How each E-R model constructs can be mapped to the relational model?

998

What is sharding?

116

What is acid db?

883

What is the maximum number of index per table?

1072