Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

Explain the etl (extraction, transformation, and loading)?

998


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

1084


What does this statement do @@rowcount?

975


Explain the steps needed to create a scheduled job?

937


What is simple indexing method?

1038


What do you understand by the data quality services in sql server?

949


State the difference between local and global temporary tables?

1120


What are the acid properties?

1007


What stored by the msdb?

1003


What is catalog views?

1071


whats the maximum size of view state??

2193


What is a rollup clause?

970


What is in place upgrade in sql server?

1046


What do you mean by tablesample?

1084


How to connect to a sql server using odbc_connect()?

1157