-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE PROCEDURE twors AS
SELECT * FROM t1
IF @@ROWCOUNT > 0 
  SELECT 1
ELSE
  SELECT 0
GO
