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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to get the rowid/rownumbes of a table in sqlserver

Question Posted / dhivakar

Answer Posted / dhivakar

SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql language?

1026

Describe different Processing Modes offered by SSRS?

232

What is full outer join in sql server joins?

981

What are the system database in sql server 2005?

982

Why would you call update statistics?

958

What is a print index?

840

Do you know what is a trace frag? Where do we use it?

955

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

982

Explain the types of indexes.

1110

What is transaction server distributed transaction?

976

How to rebuild master databse?

1028

Explain an incremental backup?

936

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2091

Explain what is lock escalation?

987

Define self join?

985