Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
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
along with your userid / name. ThanQ
Site Map
