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

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

147

How to assign null values to variables or columns?

915

What are the advantages of mirroring?

940

List some advantages and disadvantages of stored procedure?

970

What are the steps you can take to avoid “deadlocks”?

922

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

926

How to scale out a federation by Sql statement?

116

Explain the third normal form(3nf)?

897

What is sql server replication? : sql server replication

925

What does dml stand for?

908

How to send email from database?

953

What is cube dimension? : sql server analysis services, ssas

957

How to change server name in sql server?

1100

What do you understand by integration services in sql server?

922

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1169