Posted by Yas on 08/18/07 14:52

Hi, is there a way I can check if a table is empty and contains no
rows?

I have a Table1 which being dynamic can sometimes end up with now
columns what so ever. I'm using Table1 in one of my views along with 2
other tables and I would like put a condition at the...something like
AND Table1 IS NOTEMPTY

Is there a way to do this in MS SQL?

Many thanks

Yas

• Next in forum: Re: How to check if a Table is <empty> ie doesnt contain any rows
• Prev in forum: Re: Inconsistent identity values
• Thread view: How to check if a Table is <empty> ie doesnt contain any rows

[Reply to this message]