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
What is shrink log file?
Find columns used in stored procedure?
What are the types of sql server?
How to get the definition of a stored procedure back?
What are trace flags?
Explain sql server service broker?
What are translations and its use? : sql server analysis services, ssas
How exceptions can be handled in sql server programming?
what are constraints? Explain different types of constraints? : Sql server database administration
Write query to return all rows sql?
Explain some stored procedure creating best practices or guidelines?
What is linked report?
What do you understand by integration services in sql server?
Explain the rules for designing files and file groups in sql server?
How to include text values in sql statements?
