1) Select count(*) from tablename 2) sp_spaceused tablename 3) Select

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

Question Posted / mahmood

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

Answer Posted / mahmood

1) Select count(*) from tablename

2) sp_spaceused tablename

3) Select id from sysobjects where name ='tablename'
GO
Select * from sysindexes where id=? ---Put ID no. from
above query

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we call stored procedure in trigger?

953

How to download and install microsoft .net framework version 2.0?

1143

What is merge statement?

1086

Do you know what is lock escalation?

1016

What is dbcc updateusage?

1213

What are data files?

1047

What is the purpose of grouping data in a report?

971

Is INSTEAD OF trigger directly applicable to Table ?

1022

What is a database in ms sql server?

1063

How to create a trigger for insert only?

1046

How does a profiler work?

937

What is an example of a foreign key?

979

How to maintain a fill factor in existing indexes?

1007

Can we install sql server 2016 on windows 7?

1144

Explain the different types of backups available in sql server? : sql server database administration

932