-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE PROCEDURE getall AS

SELECT * FROM t1 WHERE f1 % 2 = 0

SELECT * FROM t1 WHERE f1 % 2 = 1

GO
