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 / vivek

Answer Posted / vivek

Select Count(*) as ro_no from <tablename>

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert multiple rows with a subquery?

1106

What is store procedure? How do they work?

982

In what sequence sql statement is processed?

993

How to call a function from a stored procedure in SQL Server ?

1002

Explain the difference between delete,drop and truncate in SQL Server?

1075

what are the core components of SSRS?

127

What is the difference between a function and a trigger?

1060

How to list all triggers in the database with sys.triggers in ms sql server?

1055

Explain what is lock escalation and what is its purpose?

915

What is triggers and stored procedures?

925

Suggest a method of joining two tables.

1142

Explain a checkpoint?

1011

When would you use sql joins?

939

What is a user-defined function in the sql server and what is its advantage?

1072

Explain the use of keyword with encryption. Create a store procedure with encryption?

933