February 15, 2008

count of the number of records in a table

  1. SELECT COUNT(*) FROM tableName
  2. SELECT rows FROM sysindexes WHERE id = OBJECT_ID(tableName) AND indid < 2
Posted by
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)