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
What are different types of database indexes?
What is collation sensitivity? Explain different types.
Can you use order by when defining a view?
What are indexes in ms sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What stored by the master? : sql server database administration
How to write a query with a full outer join in ms sql server?
How do I start and stop sql server?
What are the purposes of floor and sign functions?
What is the Control Flow in SSIS
Please explain what is “asynchronous” communication in sql server service broker?
What are indexers?
What is molap and its advantage? : sql server analysis services, ssas
How do you clear a log file?
What is the library index called?