-- Collection of code snippets by Arne Vajhøj 
-- from articles on eksperten.dk / vajhoej.dk (2004-now) 
CREATE PROCEDURE usp_multi @arg INTEGER
AS
BEGIN
    SELECT @arg+1 AS v
    SELECT 2*@arg AS v
END;
GO
EXEC dbo.usp_multi 2;
GO
EXEC dbo.usp_multi 4;
GO
DROP PROCEDURE usp_multi;
GO
