Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / uma lakshman
Hokar, You are right. But using count(*) is not optimal.
I wud suggest going for sysindexes table to find the number
of rows in a particular table.
SELECT rows FROM sysindexes WHERE id = OBJECT_ID
('table_name')
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What are the advantages of paper records?
What types of Joins are possible with Sql Server?
Why and when do stored procedure recompile?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What do you mean by an execution plan?
How to create an index on an existing table in ms sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are the disadvantages of using the stored procedures?
What is the use of tempdb? What values does it hold?
What are the key configuration files for sql server reporting services ?
Explain the database you used in your final year project?
Is sql server 2016 free?
Define tool Manage Statistics in SQL Server 2000 query ?
Tell about MOM Tool(Microsoft Operator Manager)?
How to filter records of table in SQL SERVER?
