-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and 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
