Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijay dev saxena
Count(expr) -> returns the number of records in the table
where the expr is not null in the particular column.
Count(*) -> returns the number of all records in the table.
(including duplicates and those with nulls)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can I run multiple instances of sql server 2000 at the same time on one computer?
How can I check that whether automatic statistic update is enabled or not?
What are the hotfixes and patches in sql server?
What is difference between rownum and rowid?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to connect Azure federated root database and apply federation in entity framework?
Define ACID properties in a Database?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How can you stop stored procedures from recompiling?
Is it possible to call a stored procedure within a stored procedure?
How do I shrink an ldf file?
What types of Joins are possible with Sql Server?
What is Replication?
What is the report model project?
What can be used instead of trigger?
