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

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

Which are the olap features?

0 Answers  

What are different types of data sources?

0 Answers  

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

When do you use SQL Profiler?

3 Answers   Wipro,

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

How column data types are determined in a view?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

How to find the second highest salary of an employee?

0 Answers  

Does sql server 2016 have ssms?

0 Answers  

What is inner join in sql server joins?

0 Answers  

Explain what are various ways to enhance the ssrs report?

0 Answers