count() @@rowcount sysindexes dbcc chektable sp

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

Question Posted / ramakrishna

5 Answers
17165 Views
eFunds, I also Faced
E-Mail Answers

Answer Posted / ramakrishna

count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused

excution plan

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why are you getting errors when creating a new odbc dsn?

1213

What is database black box testing?

1023

How to download and install sql server 2005 books online?

1168

What is the difference between varchar and nvarchar datatypes?

1080

how many no of arguments can be passed in procedures and functions

5541

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1845

What is importing utility?

976

What is an indexed view?

949

Explain active/passive and active/active cluster configurations?

1055

What are the different subsets of sql?

1532

How is a full-text index updated?

944

How to create percentile function?

151

How do I shrink an ldf file?

976

How do I create a stored procedure in sql server?

1021

How adventureworkslt tables are related?

920