How do you find the number of rows in a table?

Answer Posted / kumar.t

Select Rows From SysIndexes Where Id = Object_Id
('tablename') And IndId<2

Uma Lakshman answer is wrong.

It Is Correct Answer

By
Kumar.T

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the architecture of ms sql reporting service?

694


What is the difference between varchar and nvarchar?

678


What are the different types of normalization?

808


What is the significance of master, tempdb and model databases?

707


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

677






explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

831


Write an sql query to find first weekday of the month?

664


How can I track the changes or identify the latest insert-update-delete from a table?

714


What do you mean by a Composite primary key?

759


How to use old values to define new values in update statements in ms sql server?

867


What is the difference between a local and a global temporary table?

817


What is a view and what are its advantages?

855


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

824


How will you go about resolving deadlocks?

690


Explain few examples of stored procedure over triggers?

690