Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
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
To Refer this Site to Your Friends 
Site Map
