To get the total record count of a table use

Select count(*) from table_name
 or
select count(column_name) from table_name

1.select count(*) from <table name>
2.select  count_big(*) from <table name>
3.select rows   from sysindexes where id=?

count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused

excution plan

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

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