how to find maximum identity number in a table ?
Answers were Sorted based on User's Feedback
What is the basic functions for master, msdb, tempdb databases?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
Which institute is best for SQL Server 2005 Training?
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
What are the different methods available under sqlcommand class to access the data?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Define indexes?
How to view existing indexes on an given table using sys.indexes?
Introduction of rollup clause using sum and group by clause?
What are the advantages of having an index on the sql server?
What does indexation mean?