Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, Microsoft SQL Server, Microsoft Access, Oracle, SAP
Friday, May 17, 2013
Count of the number of records in a SQL Table
Name 3 ways to get an accurate count of the number of records in a SQL Table?
SELECT * FROM TableName
SELECT COUNT(*) FROM TableName
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('TableName') AND indid < 2
No comments:
Post a Comment