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
- 16966 Views
- eFunds, I also Faced
- E-Mail Answers
Answer Posted / mathan
1.select count(*) from <table name>
2.select count_big(*) from <table name>
3.select rows from sysindexes where id=?
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is a performance monitor?
What is the use of sql profiler in sql server 2012?
How does recursive cte works in sql server?
Explain about Normalization?
Explain the benefits of user-defined functions?
Explain error and transaction handling in sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are commonly used odbc functions in php?
what is dbcc? : Sql server database administration
How do you open a cluster administrator?
Working with TLogs
What are different types of join?
List few advantages of stored procedure.
what is the different types of backups available in sql server? : Sql server database administration
Explain about Views?
