how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
Answer Posted / naveen
place identity on a column at the time of creating table
Ex:
create table test(studentrank identity(1,1))
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain the etl (extraction, transformation, and loading)?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What does this statement do @@rowcount?
Explain the steps needed to create a scheduled job?
What is simple indexing method?
What do you understand by the data quality services in sql server?
State the difference between local and global temporary tables?
What are the acid properties?
What stored by the msdb?
What is catalog views?
whats the maximum size of view state??
What is a rollup clause?
What is in place upgrade in sql server?
What do you mean by tablesample?
How to connect to a sql server using odbc_connect()?