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
- 17164 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
Why use update_statistics command in sql server?
Mention the uses of stored procedures.
How to round a numeric value to a specific precision?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Explain identity in sql server?
What are tables in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Why Master database is required?
What are different types of schemas?
What is the difference between insensitive and scroll cursor?
Give the query of getting last two records from the table in SQL SERVER?
Do you know what is lock escalation?
Tell me what is normalization? Explain different forms of normalization?
How many types of functions are there in sql server?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
