Select Rows From SysIndexes Where Id = Object

How do you find the number of rows in a table?

Question Posted / kumar.t

Answer Posted / kumar.t

Select Rows From SysIndexes Where Id = Object_Id
('tablename') And IndId<2

Uma Lakshman answer is wrong.

It Is Correct Answer

By
Kumar.T

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Differentiate sql server reporting services vs. Crystal reports?

209

How to configure odbc dsn with different port numbers?

1154

What do you mean by subquery?

1151

What do you understand by check constraint in sql server?

1019

what is the sql equivaent of the dataset relation object ?

2070

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

What are sql server procedures?

1037

Does sql server 2000 full-text search support clustering?

915

What are two difference between sql azure and azure tables?

161

please differentiate between delete and truncate?

1041

What is meant by indexing files?

1099

What is 1nf 2nf and 3nf?

960

List some of the rules that apply to creating and using a ‘view’

927

What are the differences between sql server and mysql.

1146

How to scale out a federation by Sql statement?

118