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 |
What is mssql?
Explain the functionalities that views support?
How to delete a login name in ms sql server?
What is table level trigger?
What is optimistic concurrency?
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.
What is candidate key with example?
What is the contrast between sql and mysql?
What is difference between delete and truncate commands?
What are the type of Indexes? which one is best, why?
Tell me what is a linked server?
What happens if strings are casted into wrong code pages in ms sql server?