Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 15314 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
How do I start sql server 2016?
What is after dml trigger?
What do you mean by data integrity?
Which data type columns are the best candidates for full-text indexing?
What is collation?
Tell me what are the essential components of sql server service broker?
can you instantiate a com object by using t-sql? : Sql server database administration
Can primary key be null?
Is it possible in sql table to have more than one foreign key?
List out the differences between the clustered index and non-clustered index in sql server?
How do I perform an unattended install of sql server 2000?
Does index speed up select statements?
What is user-defined inline table-valued function?
Do I need a report server to run reports in my application?
What is the Control Flow in SSIS
