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
- 16972 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 meant by referential integrity?
What do we have to check in database testing?
What is the bookmark lookup and rid lookup?
Does transparent data encryption provide encryption when transmitting data across the network?
How do I find the default sql server instance?
How do we synchronize On-Premise SQL server with SQL Azure?
What do I need to start working with sql studio? : sql server management studio
what is the maximum size of a row? : Sql server database administration
What is primary key, unique key, and foreign key?
How to create an multi-statement table-valued function?
What is meant by datasource?
What do you know about system database? : SQL Server Architecture
What is the synonym of join?
What is implicit cursors?
What is row-level compre?
