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 is a partitioned view?

956

What is sql server english query?

1050

Explain the first normal form(1nf)?

976

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1040

How will you monitor replication latency in transactional replication? : sql server replication

1094

What is self join in sql server joins?

977

What do you understand by recursive stored procedures?

947

How do you debug a procedure in sql server?

901

what is the information that can be stored inside a bit column? : Sql server database administration

911

Describe in brief sql server monitoring ways.

1010

What is difference between count (*) and count 1?

871

How many types of keys are there?

973

Differentiate between mongodb vs. Sql server?

1040

what type of index will get created after executing the above statement? : Sql server database administration

931

Does sql server use t sql?

963