Answer / hokar

select count(*) from tablename.

Answer / uma lakshman

Hokar, You are right. But using count(*) is not optimal.

I wud suggest going for sysindexes table to find the number
of rows in a particular table.

SELECT rows FROM sysindexes WHERE id = OBJECT_ID
('table_name')

Answer / 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

Answer / raghuram

the question is how do find number of rows in a table?

select count(*) from table_name

by using this we will get exact number of rows in a table.

Answer / anand

select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)

Answer / manoj savalia

Try This

SELECT SYS_OBJ.NAME AS "TABLE NAME"
, SYS_INDX.ROWCNT AS "ROW COUNT"
FROM SYSOBJECTS SYS_OBJ, SYSINDEXES SYS_INDX
WHERE SYS_INDX.ID = SYS_OBJ.ID
AND INDID IN(0,1)
AND XTYPE = 'U'
AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'
AND SYS_INDX.ROWCNT>0
ORDER BY SYS_INDX.rowcnt DESC

Answer / elumalai.k

select @@rowcount
select count(*) from tablename

What are various aggregate functions that are available?

0 Answers  

Explain aggregate functions?

0 Answers  

Explain what is row_number function?

0 Answers  

Why we use trigger in sql server with example?

0 Answers  

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

How can you insert null values in a column while inserting the data?

0 Answers  

What is 3nf normalization?

0 Answers  

Is the primary key column of a table an index in ms sql server?

0 Answers  

How to find table changes in sql server?

0 Answers  

What do you mean by a Composite primary key?

0 Answers   Genpact,

How to write stored procedure to update the data in 10 tables

4 Answers