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
- 17212 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
Why truncate is ddl command?
What is the difference between executequery () and executeupdate ()?
Can I work with several databases simultaneously? : sql server management studio
What are triggers? How do you invoke a trigger on demand?
What is the fillfactor concept in indexes?
Why would you call update statistics?
How can we improve performance by using SQL Server profiler?
How can you control the amount of free space in your index pages?
What are the different acid properties?
What is the use of custom fields in report?
In which files does sql server actually store data?
What are the differences between substr and charindex in sql server.
How many categories of data types used by sql server?
How to delete an existing row with delete statements in ms sql server?
What is tempdb database? : SQL Server Architecture
