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

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

What is bcp? When does it used?

0 Answers  

What is b tree index?

0 Answers  

Is Sql non procedural query language?

1 Answers   Verifone,

Mention the differences between having and where clause.

0 Answers  

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

0 Answers  

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

What is 2nf normalization form?

0 Answers  

What is BCP? When do we use it?

2 Answers  

What is difference between equi join and inner join?

0 Answers  

Tell me what is difference between clustered and non clustered index?

0 Answers  

What are the differences between stored procedure and the dynamic sql?

0 Answers