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

What does it mean to normalize a database and why would you do it?

975

What is TDS(Tabular Data Stream) Gateway?

121

What is a trigger? Why we need it?

990

How to create database with physical files specified in ms sql server?

990

Define the one-to-one relationship while designing tables.

898

What are the types of normalization?

1025

Is the primary key column of a table an index in ms sql server?

959

How to check if stored procedure is running in sql server?

1046

What is sql injection? How to protect against sql injection attack?

986

How to get the number of affected rows?

996

Do you know what is sql injection?

992

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

945

New concepts of sql server 2005 use in your project.

2355

what's the difference between delete table and truncate table commands? : Sql server database administration

972

What are the properties of the relational tables?

874