Interested to Buy Any Domain ? << Click Here >> for more details...
Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 17057 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 do you understand by mirroring and mention the advantages of the mirroring?
What are data regions?
What is sql service broker?
How to provide default values to function parameters?
What is cdc in sql server?
Which are the olap features?
Difference between uniqe index and uniqe constraint?
Is INSTEAD OF trigger directly applicable to Table ?
How do database indexes work?
How does recursive cte works in sql server?
Why do we partition data?
What are constraints in microsoft sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Explain temporary table vs table variable by using cursor alternative?
What is the difference between varchar and varchar(max) datatypes?
