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
How to write an inner join with the where clause in ms sql server?
What is scrollable cursor?
ow to bring suspect mode datbase online from scratch
What is in place upgrade in sql server?
Explain the difference between functions and stored procedures in sql server?
how we use window authentication connection with sql server.?
What is difference between join and natural join?
Does full backup break log chain?
How to stop a loop early with break statements in ms sql server?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to delete a database in ms sql server?
Can you create a logon trigger in sql server 2005 express edition?
What is the difference between web edition and business edition?
Define left outer join in sql server joins?
Do you know what is a linked server in sql server?