Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 15322 Views
- eFunds, I also Faced
- E-Mail Answers
Answer Posted / madhu
To get the total record count of a table use
Select count(*) from table_name
or
select count(column_name) from table_name
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
what is the difference between count(*) and count(1) ?
What is difference between clustered index and non clustered index?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I know if localdb is running?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are constraints in microsoft sql server?
where can you add custom error messages to sql server? : Sql server administration
In what version of sql server were synonyms released?
What is difference between createstatement and preparedstatement?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What are dml triggers and types of dml triggers?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What do you mean by data integrity?
What is the difference between delete and truncate statements?
