CREATE PROCEDURE test_sproc_with_mixed_params
(
    @input_text varchar(20),
	@output_number int     output,
	@input_first_number int,
	@output_text   varchar(10) output,
	@input_second_number int
)
AS
BEGIN
    select @output_number = 15

    select @output_text = 'results'
END