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
What are the difficulties faced in cube development? : sql server analysis services, ssas
How to loop through the result set with @@fetch_status?
How to use “drop” keyword in sql server and give an example?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Can you explain powershell included in sql server 2008?
Is foreign key a primary key?
What is xdr?
How and why use sql server?
How to start sql server browser service?
How to modify an existing user defined function?
What's the information that can be stored inside a bit column?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What are the different SQL Server Versions you have worked on?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Where can you find the error log information? : sql server database administration