Discussion Locked

Checking for Empty Tables in SQL

0 helpful

3 replies

by henry.a.penaranda Oct 16, 2002 last reply Nov 17, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to import a table, but before I connect and import i would like to check if the table is populated with data. Any help on proper SQL queries.

3 replies

How about this:
DECLARE @NumRows INT
SELECT @NumRows = COUNT(*) FROM mytable
IF @NumRows > 0
BEGIN
...
END

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.