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
List some advantages and disadvantages of stored procedure?
What are approximate numeric data types in ms sql server?
How can we determine what objects a user-defined function depends upon?
What is the difference between varchar and nvarchar?
What are the types of user defined functions in sql server?
How to disable a login name in ms sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Explain the steps to create and execute a user-defined function in the sql server?
What are the different types of collation sensitivity in sql server?
What are the difference between primary keys and foreign keys?
How to update muliple row in single query?
How do you identify a foreign key?
Where to find ntwdblib.dll version 2000.80.194.0?
How many types of functions are there in sql server?
How to use column default values in insert statements in ms sql server?