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
How to add more data to the testing table in ms sql server?
What are the differences between web role and worker role?
How to truncate the log in sql server 2012? : sql server database administration
What is triggers in ms sql server?
Why should you use or avoid select * statements?
What is raiseerror? What is raiseerror?
How can you check the level of fragmentation on a table?
Where the sql logs gets stored?
Explain subquery and state its properties?
What is the difference between NOROW and LOCKROW?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What does the on delete cascade option do?
What does this statement do @@rowcount?
How do I run a trace in sql server?
What is set nocount on?
