SELECT IDENT_CURRENT('table

how to find maximum identity number in a table ?

Question Posted / arvind rohit

2 Answers
13064 Views
JPMorgan Chase, Thomson Reuters, Wipro, I also Faced
E-Mail Answers

Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

33 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a large table with random data for index testing in ms sql server?

1033

What is precedence constraint?

990

Can truncate be rolled back?

953

What is the sql case statement used for?

1104

How to define output parameters in stored procedures?

1030

What is the difference between delete and truncate statements?

1085

What is a non clustered primary key?

928

Describe different Processing Modes offered by SSRS?

251

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2028

How to enter date and time literals in ms sql server?

1020

What is the sql profiler?

947

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1004

What should be the fill factor for indexes created on tables? : sql server database administration

1143

Explain about extended stored procedure?

948

How to convert a table data in XML format in sql server?

2547