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 to start and end transact-sql statements?

971

What are drillthrough reports?

141

How will you find out if there are expensive SQL statements running or not?

969

What are the built in functions in sql server?

919

How to enable/disable indexes?

1016

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

161

What is the difference between mysql and mysqli?

1088

explain the storage models of olap? : Sql server database administration

889

Why does sql studio use a single registered database repository? : sql server management studio

956

What is difference between Datepart() and Datename() in SqlServer?

1158

What new changes are being made in SQL Server?

1100

How to delete all rows with truncate table statement in ms sql server?

932

What is the Disadvantage of indexed sequential file.

1029

Write SQL queries on Self Join and Inner Join.

1072

How to find Duplicate Records In table?

962