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 contrast amongst drop and truncate?

1078

How do you start single user mode in clustered installations?

984

What is stretch database in sql server?

1117

Do you know what are the properties of the relational tables?

1067

What is db stored procedure?

943

What is a file group?

1163

what is checksum in sql server.........???

1744

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1053

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1257

Explain the steps to create and execute a user-defined function in the sql server?

1016

What are the ways available in sql server to execute sql statements?

1204

What do you understand by recursive stored procedures?

1043

What is right outer join in sql server joins?

1216

How do you debug a procedure in sql server?

992

Why use cursor in sql server?

1130