-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE PROCEDURE usp1
@f1 INTEGER
AS
SELECT * FROM t1 WHERE f1 > @f1
GO

CREATE PROCEDURE usp2
AS
SELECT * FROM t1 WHERE f1 > 1
GO
