In the program I'm currently writing there is a point where I need to check whether a table is empty or not. I currently just have a basic SQL execution statement that is
Count(asterisk) from Table
from (select top 1 *
You are looking for an indication if the table is empty. For that SQL has the EXISTS keyword. If you are doing this inside a stored procedure use this pattern:
IF(NOT EXISTS(SELECT 1 FROM dbo.MyTable)) BEGIN RAISERROR('MyError',16,10); END;
IF you get the indicator back to act accordingly inside the app, use this pattern:
SELECT CASE WHEN EXISTS(SELECT 1 FROM dbo.MyTable) THEN 0 ELSE 1 END AS IsEmpty;
While most of the other responses will produce the desired result too, they seem to obscure the intent.