Powered By Blogger

Sunday 22 April 2012

Difference Between FUNCTION AND PROCEDURE


Procedure Vs Function
                    Procedure
                   Function
1. Procedure doesn’t contain return clause in header & executable part.

2. Procedure may be return or may not be return a value.

3. Procedure can’t be called into select statements.

4. Procedure are used to implement business logic.
1. Function contain return clause in header & executable part.

2. Function always returns a value.


3. Function can be called into select statement.

4. Function are used for numeric calculation.

No comments: