SELECT IDENT_CURRENT('table

how to find maximum identity number in a table ?

Question Posted / karthikeyan

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

Answer Posted / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how many layers of tcp/ip protocol combined of? : Sql server database administration

997

Explain what is log shipping?

1136

What is factless fact table? : sql server analysis services, ssas

1028

What is sql server locking?

992

What is the difference between for auto and for nested?

1001

What is difference between sql and sql server?

1001

What is temporal data type?

921

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1016

What are audit control procedures?

990

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1140

What are pages and extents? : SQL Server Architecture

1017

Give an example of SQL injection attack ?

1006

What is cached report?

143

How to install sql server 2005 express edition?

1122

what exactly sql injuction.how to overcome.....

2544