1. Select Count(EmployeeId) As NoOfRow From Employee 2. Select Count(*) As

Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?

Question Posted / kumar.t

5 Answers
17378 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

Please Help Members By Posting Answers For Below Questions

How to provide values to user defined function parameters?

1060

What is log cache in sql server?

1097

What is data modification?

1017

Can you explain full-text query in sql server?

1057

What is the default server name for sql server?

1230

What is a cursor, index in sql?

1126

Explain filtered indexes?

1041

How do I start sql server agent automatically?

1027

Differentiate between SQL and ORACLE joins and write their syntax.

1071

What are the drawbacks of reporting in ssrs?

159

How to retrieve error messages using mssql_get_last_message()?

1100

Which are the olap features?

1006

What are sql server procedures?

1035

SQL Server Architecture ?

2520

Why normalization is used?

1067