differnce b/w stored procedure & function & view

[Sinesh]

Hi dear friends,
I want to know details regarding what exactly stored procedure,view, functions in SQL and their advantages and difference

[avkdsiva]

Stored Proc: is as good as a procedure in programing languages and returns nothing. But, you can return values using out/inout parameters. Cannot be used within a select statement

Function: returns a value. Can be used within a select statement.

View: Logical Snapshot of the table