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
- 17177 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
Tell me what is difference between clustered and non clustered index?
List the different types of joins?
What is the purpose of object explorer and its features? : sql server management studio
What is correlated subquery in sql server?
What is the primary use of the model database?
Name few of the dcl commands in sql?
How to return the date part only from a sql server datetime datatype?
How does using a separate hard drive for several database objects improves performance right away?
How to enter date and time literals in ms sql server?
What is log in sql server?
Explain security with sql azure?
What is normalization and what are the advantages of it?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How does recursive cte works in sql server?
How to delete a database in ms sql server?
