how to find maximum identity number in a table ?

Question Posted / subash

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

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

Post New Answer

More SQL Server Interview Questions

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers Tech Mahindra,

What is efficiency data?

0 Answers

What is the difference between system objects and user objects?

0 Answers HCL,

What is the difference between count and distinct count?

0 Answers

can any body tell me how to know the password of current user in sql server

0 Answers Crea, HCL,

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers

Simple example for difference between select and cursor in sql