1.select count(*) from <table name> 2.select count

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

Question Posted / mathan

Answer Posted / mathan

1.select count(*) from <table name>
2.select count_big(*) from <table name>
3.select rows from sysindexes where id=?

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can you always create a cache of a report?

172

What are the difficulties faced in cube development? : sql server analysis services, ssas

1041

Explain timestamp datatype?

969

Which are ddl commands?

1046

What is difference between views and stored procedures?

989

What happens if the update subquery returns multiple rows in ms sql server?

1125

Does index speed up select statements?

1010

What is a livelock?

966

What happens if ntwdblib.dll is missing on your machine?

1144

How to use the inserted and deleted pseudo tables?

961

What are magic tables in sql server?

1133

What are the different Topologies in which Replication can be configured?

1183

How to create new table with "create table" statements?

1107

Differentiate between truncate vs delete in mssql?

1083

What are the lambda triggers?

904