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 |
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?
16 Answers Accenture, IBM, Marlabs,
what is Archive old data?
Explain different backup plans?
What are commonly used mssql functions in php?
What is exporting utility?
Write an sql query for deleting duplicate rows?
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?
1 Answers CarrizalSoft Technologies,
What are different types of database indexes?
How to create indexed view?
How to define the name and server for a new dsn?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What do you understand by the denormalisation?