Microsoft SQL Server 2005 checks to see if a temporary table is lost

Question

Is there a quick / efficient way to check if a table is empty?

DECLARE @StartEndTimes TABLE
(
    id bigint,
    StartTime datetime,
    EndTime datetime
)

IF @StartEndTimes IS NOT NULL

+2

Kevin Apr 14. 10 at 19:15

2 answers

I think your best bet might be COUNT

DECLARE @StartEndTimes TABLE 
( 
    id bigint, 
    StartTime datetime, 
    EndTime datetime 
)

SELECT COUNT(1) FROM @StartEndTimes

+1

Adriaan stander Apr 14. 10 at 19:17

Alex K. · Accepted Answer · 2010-04-14T19:29:54+0000

Instead of counting, you can:

if exists (select id from @StartEndTimes)
   set @has_stuff = 1

which will return as soon as it hits the string.