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

Why do you want to join software field as you have done your BE in Electronics?

2129

explain how to create a new schema in a database? : Sql server database administration

1093

What are the different type of replication in sql server?

967

What is spatial and temporal data?

975

Are all views updatable ?

1134

What is dynamic cursor in SQL SERVER?

1054

What happens if date-only values are provided as date and time literals?

1003

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

4354

What are cursors stored procedures and triggers?

986

Explain different types of lock modes in sql server 2000?

922

What are the 2 types of classifications of constraints in the sql server?

1100

What is difference between primary key and foreign key?

882

What encryption security is available in sql azure?

101

What does it mean to invest in the index?

942

What is sql stored procedure?

1062