Answer Posted / rajeeva tripathi
count - It returns the non null values
count(*) - It returns the null values and duplicate values
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where in ms sql server is ’100’ equal to ‘0’?
What is sql sandbox in sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How do I create a stored procedure in sql server?
What are the requirements on sql server network connections?
What is the difference between dataadapter and datareader?
How to join two tables in a single query in ms sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How to create a scrollable cursor with the scroll option?
what are constraints? : Sql server database administration
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the advantages of sql stored procedure?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What are the basic features of a trigger in ms sql server?
Are null values the same as that of zero or a blank space?