Check whether a table contains rows or not sql server 2005

How to Check whether a table contains rows or not sql server 2005?

Solution

For what purpose?

Quickest for an IF would be IF EXISTS (SELECT * FROM Table)...
For a result set, SELECT TOP 1 1 FROM Table returns either zero or one rows
For exactly one row with a count (0 or non-zero), SELECT COUNT(*) FROM Table

Base64 encoding in SQL Server 2005 T-SQL
SQL Email Verification Function using Regex
Execution sequence of Group By, Having and Where clause in SQL Server?
Convert Month Number to Month Name Function in SQL
SQL Server 2005 Get First and Last date for any Month in any Year
Trunc(sysdate) in SQL Server
Why use the INCLUDE clause when creating an index?
SQL 8115 Arithmetic overflow error converting numeric to data type numeric
Parse DateTime Parameter
How to convert database diagrams in SQL Server 2005 to other formats?
Disadvantages of MARS (Multiple Active Result Sets)?
How to change a table name using an SQL query?
Unable to Connect to Local SQL Server with Windows Authentication using SSMS
Can I add a not null column without DEFAULT value
How to select rows for a specific date, ignoring time in SQL Server 2005 or earlier
Retrieving last record in each group from database - SQL Server 2005/2008
How to get the name of a the student who got max marks in each subject?
How to copy a huge table data into another table in SQL Server
How to dynamically set the value of a parameter in sp_executesql without modifying the calling software
Why can't I perform an aggregate function on an expression containing an aggregate but I can do so by creating a new select statement around it?
How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
Check whether a table contains rows or not sql server 2005
How to identify all stored procedures referring a particular table
Check if table exists in SQL Server
Remove trailing spaces from fixed length in output file generated by sqlcmd
Sqlcmd to generate file without dashed line under header, without row count
Cannot connect to SQL Server express from SSMS
Loop through databases on server, and update data
An expression of non-boolean type specified in a context where a condition is expected, near 'END'
How to get previous row value