use pubs
go
if(select count(*) from authors )=0
begin
print 'no data'
end
else
begin
print 'has data'
end
go
IF NOT EXISTS ( select name from sysobjects where type ='U' and id = object_id('tablename'))
begin
print 'not exist'
end
else
begin
print 'exist'
end
go