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
- 16971 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 is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What are the extra roles available in msdb? : sql server security
How can I check that whether automatic statistic update is enabled or not?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are the different types of backups that exist?
How to test odbc dsn connection settings?
How to delete duplicate rows in sql server?
How to create a store procedure with encryption?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is optimization and its types?
Explain differences between web edition and business edition?
‘Order by’ is not allowed in a view how can you sort information from a view?
Which table keeps the locking information?
How check triggers in sql server?
