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

What is the difference between a function and a stored procedure?

1125

What does nvl stand for?

993

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1086

What is temporal data type?

967

What happens if you are trying to access a schema not owned by you?

1020

What is collation?

1195

What is after dml trigger?

1063

What are the restraints imposed on the table design by a merge replication?

1090

Explain what are sparse columns?

1067

Can you explain full-text query in sql server?

1059

What is update locks?

937

Explain some stored procedure creating best practices or guidelines?

1003

What is database replication?

1210

What is the data tier application?

169

Explain what is use of dbcc commands?

1132