Parameterised Stored procedure with select query and output parameter

 create proc sp_test_select_output

(

@id int,

@rtnval int output

)

as 

begin

select * from tblCities;

select @rtnval = @@ROWCOUNT;

end

--declare @output int;

--exec sp_test_select_output 0, @output output;

--select @output as 'OUT PUT'