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 the differences between char and varchar in ms sql server?

1051

What do you understand by intent locks?

1000

Where do we use trace frag?

1005

What are the rendering extensions of ssrs?

155

List out a number of the wants to setup a SQL Server failover cluster?

1056

How do I open a .db file?

1026

How do I view a stored procedure in sql server query?

918

What is clustered vs nonclustered index?

934

What is the purpose of sql profiler in sql server? : sql server database administration

1096

Explain full-text indexing?

970

What is a benefit of using an after insert trigger over using a before insert trigger?

976

What is BLOCK statements in SQL?

1257

What is bcnf normalization form?

1101

Should you normalize audio?

932

Can sql servers linked to other servers like oracle?

938