Interested to Buy Any Domain ? << Click Here >> for more details...
Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 17023 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
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is collation sensitivity?
Can we deploy SSRS reports on our personal website?
Explain the different index configurations a table can have?
How to configure odbc dsn with different port numbers?
Explain the microsoft sql server delete command?
Can I use sql azure as a backup with log shipping or database mirroring?
How can you start sql server in different modes?
What does nvl stand for?
How to apply filtering criteria at group level with the having clause in ms sql server?
Explain cross join or cartesian product in sql?
What is a sql join?
What is clr ddl trigger?
how to do partition in sqlserver
What are the aggregate and scalar functions?
