Interested to Buy Any Domain ? << Click Here >> for more details...
how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
- 4 Answers
- 8050 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
In which tcp/ip port does sql server run? Can it be changed?
What are subqueries in sql server?
How to manipulate data from one table to another table ?
Can we perform backup restore operation on tempdb? : sql server database administration
Do you know what is a trace frag? Where do we use it?
What are data files?
Differentiate between ms sql server reporting services vs crystal reports?
Can we join two tables without primary key?
what are the different types of SSRS reports?
List out a number of the wants to setup a SQL Server failover cluster?
In case you have filters in your report, when filters will be applied in cached report instance?
How ssrs maintain security?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to convert binary strings into integers in ms sql server?
When you use @@error and try-catch?
