how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
- 4 Answers
- 7191 Views
- ABC, I also Faced
- E-Mail Answers
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
Can you explain various data region available in ssrs with their use?
What is the difference between composite index and covering index?
which table keeps the locking information? : Sql server administration
How to delete existing triggers using "drop trigger"?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Determine when to use stored procedure to complete sql server tasks?
What is the use of group by clause?
Can a function call a stored procedure in sql server?
Does table partitioning improve performance?
Is mysql better than sql server?
What are security principals used in sql server 2005?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How ssrs maintain security?
What is the purpose of linked server configuration in sql server?
