Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
Answers were Sorted based on User's Feedback
Answer / kumar.t
1. Select Count(EmployeeId) As NoOfRow From Employee
2. Select Count(*) As NoOfRow From Employee
3. Select Count_Big(*) As NoOfRow From Employee
4. Select Rows From SysIndexes Where Id = Object_Id
('Employee') And IndId<2
By
Kumar.T
Is This Answer Correct ? | 12 Yes | 5 No |
Answer / madhu
To get the total record count of a table use
Select count(*) from table_name
or
select count(column_name) from table_name
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / mathan
1.select count(*) from <table name>
2.select count_big(*) from <table name>
3.select rows from sysindexes where id=?
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / ramakrishna
count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused
excution plan
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / mahmood
1) Select count(*) from tablename
2) sp_spaceused tablename
3) Select id from sysobjects where name ='tablename'
GO
Select * from sysindexes where id=? ---Put ID no. from
above query
Is This Answer Correct ? | 1 Yes | 4 No |
Which trace flags are enabled in sql server?
What are the differences between substr and charindex in sql server.
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
why would you use sql agent? : Sql server database administration
What are the parts of a function?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
What is the difference between set and select?
Describe in brief sql server monitoring ways.
How will u get 5 years back record?
What is join and name different type of joins?
What do you understand by coalesce in sql server?
What is the significance of master, tempdb and model databases?