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
What objects does the fn_my_permissions function reports on? : sql server security
What is a synonym for manipulation?
how to use DTS package in 2000,2005,2008 in sql server
How to insert data into an existing table?
What is a transactions?
How to recreate an existing index in ms sql server?
What is auditing in sql server?
What is row-level compre?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How can I create a new template for import ? : sql server management studio
What is stored in the mssqlsystemresource database? : sql server database administration
what kind of lan types do you know? : Sql server database administration
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is a linked server in sql server?
How to create database with physical files specified in ms sql server?