To get the total record count of a table use Select count(*) from table

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

Question Posted / madhu

Answer Posted / madhu

To get the total record count of a table use

Select count(*) from table_name
or
select count(column_name) from table_name

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is lookup override?

592

What are the disadvantages of indexes?

540

What is merge join?

582

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

546

Can two tables share a primary key?

528

What are logical/boolean operations in ms sql server?

547

What happens if date-only values are provided as date and time literals?

552

What are different types of database indexes?

539

Does union all remove duplicates?

620

What is a result set object returned by odbc_exec()?

554

Explain different types of locks in sql server.

607

How to create a store procedure with encryption?

527

Explain few examples of stored procedure over triggers?

528

How do I know if localdb is running?

523

Do you know how to send email from database?

556