SP Default Parameter , OutPut | Function - Scalar
More SP Example
SubQueries ( List , Table , Scalar ) , Simple Stored Procedures