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
A trigger can reference objects outside the current database? State true or false.
How do I find the port number for sql server?
Is t sql the same as sql server?
What is query and its types?
Explain the collation?
How do you open a cluster administrator?
How to define output parameters in stored procedures?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is SQL Azure Data sync?
What is report subscription?
How to find the source of a table in sql server?
What are the advantages of user defined function?
Explain the difference between HTTP and HTTPS in database?
What is the rdl file?
Who is the owner of a schema in ms sql server?