how to find maximum identity number in a table ?
Answer Posted / karthikeyan
SELECT IDENT_CURRENT('table_name') ;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to insert data with null values?
How is sql server used?
What is the use of toad or sqldbx.?
What is an index in a database?
What is the difference between varchar and varchar(max) datatypes?
what are constraints? Explain different types of constraints? : Sql server database administration
What are the advantages of stored procedure in sql server?
Why do we use stored procedures in sql server?
What command would you use to create an index?
What are the different types of join?
Can sql servers link to other servers?
Do you know what are the steps to process a single select statement?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the lambda triggers?
ow to bring suspect mode datbase online from scratch