Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 15411 Views
- eFunds, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
1. Select Count(EmployeeId) As NoOfRow From Employee
2. Select Count(*) As NoOfRow From Employee
3. Select Count_Big(*) As NoOfRow From Employee
4. Select Rows From SysIndexes Where Id = Object_Id
('Employee') And IndId<2
By
Kumar.T
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
What is an index. What are the types?
Explain SSRS Architecture?
Can you leave a union at any time?
What do you understand by a stored procedure?
Can a table be created inside a trigger?
Explain an automatic checkpoint
Explain data warehousing in sql server?
What is shrink log file?
How to achieve Paging of records in SQL SERVER?
Does index slows down insert statements?
What is statement level trigger?
How many levels of sp nesting is possible?
What is the process of normalization?
What is table level trigger?
How fixed length strings are truncated and padded?
