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 are trace flags?

959

Which joins are sql server default?

937

How to select an exiting database using mssql_select_db()?

910

What are triggers? How do you invoke a trigger on demand?

1243

What are types of storage modes? : sql server analysis services, ssas

984

Which tcl commands are available on the sql server?

1016

What is data modification?

896

Explain about protocol layer present in SQL server?

1103

How do I debug a stored procedure in sql server?

1027

What are the methods used to protect against sql injection attack?

1000

How to deploy the Report?

125

What is built-in/administrator?

956

What is 1nf normalization form?

979

What is a functions and types in sql server?

1011

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

942