-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE PROCEDURE nonempty
AS
DECLARE @n INTEGER
SET @n = (SELECT COUNT(*) FROM t1)
IF @n > 0
    SELECT * FROM t1
ELSE
    SELECT 0,0
RETURN
GO
