CREATE PROCEDURE test_sproc_with_output_params ( @output_number int output, @output_text varchar(10) output ) AS BEGIN select @output_number = 15 select @output_text = 'results' END