how to find maximum identity number in a table ?

Question Posted / subash

Answers were Sorted based on User's Feedback

how to find maximum identity number in a table ?..

Answer / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

33 Yes

5 No

how to find maximum identity number in a table ?..

Answer / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Is This Answer Correct ?

13 Yes

0 No

More SQL Server Interview Questions

What is optimization and its types?

Give a example to search fr a string in all stored procedure in sql server.

how many bits ip address consist of? : Sql server database administration

Explain datetimeoffset data type in sal server 2008?

What is field in algebra?

What are distributed partitioned views?

Difference between writing SQL query and stored procedure ?

What is an indexing strategy?

What happens if date-only values are provided as date and time literals?

Write SQL queries on Self Join and Inner Join.

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

what is Data Transformation Services (DTS) ?can u explain me in detail?

For more SQL Server Interview Questions Click Here