Stored Procedure in Sql Server

Question

Hi,

I have a confusing in stored procedure in sql, whether stored procedure returns a value or not . If it returns, then what types of value we can returned by the stored procedure?


Plz reply..