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
Determine when an index is appropriate?
What are data driven subscriptions?
Define tool Manage Statistics in SQL Server 2000 query ?
What is a benefit of using an after insert trigger over using a before insert trigger?
What are a scheduled jobs?
What is a data source or ds? : sql server analysis services, ssas
What is a database table?
How to count rows with the count(*) function in ms sql server?
How you can get a list of all the table constraints in a database?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is the size of transaction log file?
Define left outer join?
How to drop existing views from a database in ms sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
What is the minimum recommended amount of ram for sql server 2012 enterprise?