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
What is RAID? What are the different types of RAID configurations?
What is the meaning of sql server?
Determine how to use the inserted and deleted pseudo tables?
Write a SQL query to make a column as unique?
What are parameterized reports? What are cascading parameters in ssrs reports?
What are information schema views?
Why the trigger fires multiple times in single login?
Explain syntax for viewing trigger?
Can group functions be used in the order by clause in ms sql server?
What is the difference between executequery () and executeupdate ()?
What is merge statement?
Explain alternate key, candidate key and composite key in sql server?
What is log cache in sql server?
Do you know what is sql injection?
Explain left outer join and right outer join?
