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
Explain something about security and SQL Azure?
What purpose does the model database server?
What is the use of tempdb? What values does it hold?
What is key attribute?
What is bulkcopy in sql?
Why use cursor in sql server?
What happens if we shrink log file in sql server?
What are the instances when triggers are appropriate?
What are the disadvantages of merge replication?
Explain Capacity planning to create a database? and how to monitor it?
What is the difference between migration and upgradation in sql server?
What is an entity-relationship diagram (erd)?
Tell me what is de-normalization and what are some of the examples of it?
What does asynchronous call backs means?
What is the minimum recommended amount of ram for sql server 2012 enterprise?