how to find maximum identity number in a table ?
Answer Posted / arvind rohit
SELECT IDENT_CURRENT('table_name') ;
| Is This Answer Correct ? | 33 Yes | 5 No |
Post New Answer View All Answers
Differentiate between SQL and ORACLE joins and write their syntax.
How do you rename a table in sql server?
What are the steps you will take to improve the performance of a poor performing query?
What is the process of indexing?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Which data type columns are the best candidates for full-text indexing?
Explain about unique identifier data type in sql server?
What is a document index?
How do I find information about the install locations for the various instances running on a computer?
What is parameterized reports in ssrs ?
What is create command?
If no size is defined while creating the database, what size will the database have?
How to provide default values to function parameters?
Does transparent data encryption provide encryption when transmitting data across the network?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?