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 are recommended options to be used while using db mirroring? : sql server database administration

1223

Explain different types of lock modes in sql server 2000?

982

What are null values in ms sql server?

1142

What’s the distinction between dropping a info and taking a info offline?

1090

How to create a Master database in SQL server ?

1140

How do I start sql server agent automatically?

1027

What is acid mean in sql server?

1198

What do you understand by the denormalisation?

1020

What is the use of custom fields in report?

1041

What is a linked server in sql server?

1132

how to create a scrollable cursor with the scroll option? : Sql server database administration

1147

How to create a local temporary stored procedure?

1047

Explain tablesample?

1038

What are translations and its use? : sql server analysis services, ssas

1082

What are locks in sql?

1014