Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Num of rows in a table

Author  Topic 

R@bb1t
Starting Member

28 Posts

Posted - 2008-01-24 : 02:24:08
How can I determine the number of rows in a table??

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-01-24 : 02:29:45
search "determine the number of rows in a table sql server" on google. You will find how to get.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-24 : 02:48:59
SELECT COUNT(*) FROM Table
Go to Top of Page

R@bb1t
Starting Member

28 Posts

Posted - 2008-01-24 : 03:58:38
I already know dat u can return the no of rows of a table by this statement.. This is not wat I want... I am not making mockery of u guys

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95738
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-24 : 04:01:44
Than what were you asking for? Please make your question clear.
Go to Top of Page

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-01-24 : 04:03:33
Why don't you then put your query clearly? If you keep writing "How can I determine the number of rows in a table" this, you will get the same replies as above. State clearly what you want to achieve.

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -