How do you find the number of rows in a table?
Answers were Sorted based on User's Feedback
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')
Is This Answer Correct ? | 12 Yes | 3 No |
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
Is This Answer Correct ? | 12 Yes | 3 No |
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.
Is This Answer Correct ? | 10 Yes | 1 No |
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)
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
select @@rowcount
select count(*) from tablename
Is This Answer Correct ? | 5 Yes | 7 No |
What is cursor in ms sql server?
How to defragment indexes with alter index ... Reorganize?
which one will take 1st priority in case of insert statement and select statement???
what is the difference between table and view
how many layers of tcp/ip protocol combined of? : Sql server database administration
If we shrink the Databse and Files, how much size is decreased?
How to override dml statements with triggers?
What does it mean to manipulate data?
What is the difference between SSAS 2000 and SSAS 2005?
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
What's the information that can be stored inside a bit column?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication