Select Count(*) as ro_no from <tablename>

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

Question Posted / vivek

Answer Posted / vivek

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is primary key index?

987

Can a cursor be updated? If yes, how you can protect which columns are updated?

1117

How can we call UDF(User Define Function) using C# code in ASP.net ?

6895

Describe how to use linked server?

1027

How many columns can we include on clustered index ?

999

what is a schema in sql server 2005? : Sql server database administration

1037

How to retrieve error messages using mssql_get_last_message()?

1061

What is read committed?

1104

What is the difference between dropping a database and taking a database offline?

1178

How to fetch the next row from a cursor with a "fetch" statement?

1075

What programming language would you use to create embedded functions in ssrs?

186

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

994

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4395

Does server sql treat char as a variable-length or fixed-length column?

1051

How do you size a resultset?

922