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

Ms sql server index?

1063

What are the ways available in sql server to execute sql statements?

1135

How to make remote connection in database?

1005

How to identify current user in ssrs report?

403

What is the difference between count and distinct count?

882

What is sqlservr.exe - process - sql server (sqlex?press)?

1108

What is the use of nvl work?

1004

What are the types of indexing?

1082

How many types of subqueries are there in sql server?

992

How do you delete a trigger?

979

How to update values in a table with update statements in ms sql server?

1013

What is unpivot?

1011

Tell me what is log shipping?

977

Difference between LEN() and DATALENGTH() in sql server ?

1104

How network traffic be reduced by using the stored procedure?

1118