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 the significance of null value and why should we avoid permitting null values?

988

Which sql server table is used to hold the stored procedure scripts?

1062

How to create a store procedure with encryption?

1006

What is triggers and stored procedures?

943

Explain what are commit and rollback in sql?

933

What is a print index?

886

can an automatic recovery be initiated by a user? : Sql server administration

956

Why do we partition data?

1031

Is there any difference between primary key and unique with the not null condition?

952

What are different types of subquery?

1245

What is NOT NULL Constraint in sql server 2012?

1000

What is DCL?

1053

How to find out the list schema name and table name for the database?

942

How many joins in sql server?

958

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1064