Tuesday, May 05, 2015

Name 3 ways to get an Accurate Count of the Number of Records in a Table?

Posted by Rahul Kharde at 10:27 AM

 

  1.  SELECT COUNT(*) FROM table1   
  2.  SELECT * FROM table1
  3.  SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2




If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to my regular Email Updates. Subscribe Now!


Kindly Bookmark and Share it:

YOUR ADSENSE CODE GOES HERE

0 comments:

Have any question? Feel Free To Post Below:

 

Popular Posts

Recent Comments

© 2011. All Rights Reserved | Help to understand .Net | Template by Blogger Widgets

Home | About | Top