Answer Posted / harish sharma
Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain different types of index?
Can we call stored procedure in view in sql server?
What is report subscription?
Explain powershell included in sql server 2008?
Is sql server a database?
How to retrieve field values using mssql_result()?
What is sql server database?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Other than truncate statement, which other command can by-pass the trigger on the tables?
How many primary keys are possible in a table?
Explain hostprotectionattribute in sql server 2005?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is a rollup clause?
What is SQL Azure Federations?