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
Explain collation?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How do you check sql server is up and running?
Can binary strings be used in arithmetical operations?
what is the primary use of the model database? : Sql server administration
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What triggers long term care?
What are views used for?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are functions in the sql server?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Define msdb database?
What is a view and what are its advantages?
What is the use of sql profiler in sql server 2012?
What is a db view?