Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

Name 3 ways to get an accurate count of the number of records in a table?

Add comment
Views: 102
Votes: 0
Comments: 0
SELECT * FROM table1

SELECT COUNT(*) FROM table1

SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2
Others in this Category
document Q: What are the Various Master and Detail Relation ships.
document What is BCP? When does it used?
document What are different Types of Join?
document What is User Defined Functions? What kind of User-Defined Functions can be created?
document What is Aggregate Functions?
document Q: What are various constraints used in SQL?
document How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
document Q: What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?
document What is Normalization?
document Which TCP/IP port does SQL Server run on? How can it be changed?
» More articles



RSS