-- 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 usp1
@f1 INTEGER
AS
SELECT * FROM t1 WHERE f1 > @f1
GO

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