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 encryption of entire databases without the need for application changes in sql server 2008?
Explain linked server in sql?
What is the stuff?
Describe and explain about SQL native client?
What is the language structure to add a record to a table?
What is the difference between NOROW and LOCKROW?
What is the difference between an index and a unique index?
How you can move data or databases between servers and databases in sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How can change procedure in sql server?
What is the recursive stored procedure in sql server?
How does clustered and non clustered index work?
What is difference between clustered and non clustered index?
Can you pass expressions to stored procedure parameters?
What are the different types of Indexes available in SQL Server?