Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Can you create a logon trigger in sql server 2005 express edition?
What are the differences between substr and charindex in sql server.
What are different types of subquery?
What are clustered and non-clustered index?
Where do you find the default Index fill factor and how to change it?
What are indexes in sql?
What is self contained scalar sub query?
Explain what are sparse columns?
What is difference between join and natural join?
What is meant by Active-Passive and Active-Active clustering setup?
What are the security related catalog views? : sql server security
What are the restraints imposed on the table design by a merge replication?
What does asynchronous call backs means?
What is the recursive stored procedure in sql server?
What is logshipping and its purpose?
