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
Differentiate between a primary key and a unique key.
How to achieve Paging of records in SQL SERVER?
Why use cursor in sql server?
What are the system database in sql server 2005?
Can primary key be a foreign key?
What are security principals used in sql server 2005?
Should you normalize audio?
List the data types available in mssql?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What new data source types were added in ssrs 2014?
What is your recommendation for a query running very slow? : sql server database administration
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is federation member?
How to Insert multiple rows with a single insert statement?
Write a SQL query to make a column as unique?