Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anand
select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why should you use or avoid select * statements?
How will you find out if there are expensive SQL statements running or not?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is row_number () and partition by in sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the difference between Normalization and De-normalization?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What are three major types of constraints?
how to take backup bcp out for a column in table in sql server?
What is the Difference Between Primary and Foreign Key?
What are clustered and non-clustered index?
How to verify the port number of the sql server?
Can we add an identity column to decimal datatype?
