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
Why use stored procedures in sql server?
What is the library index called?
What is the order by used for?
What is function of ROLLUP ?
Which is better statement or preparedstatement?
Do you know what is a trace frag? Where do we use it?
What is the difference between varchar and varchar types?
Does union all remove duplicates?
Explain different types of collation sensitivity?
What is the stuff and how does it differ from the replace function?
Is the log file is a part of file group?
Difference between LEN() and DATALENGTH() in sql server ?
How retrieve field names from the table in SQL through JAVA code?
Does group by or order by come first?
What are diverse clauses that form a part of sql?
