CREATE PROC sp_proc1
          @param int OUTPUT
     AS
          SELECT @param = 1
          RETURN 0