Diff B/w Stored Procedures & Functions

[mansi sharma]

Functions ia a block of code that performs some task & returns value.

Can somebody tell me What are Stored Procedures?
I found abt Stored procedues from the Net-->Stored Procedures is a group of SQL statements that form a logical unit and perform some task.

Above defintion of Stored procedures is same as functions.
Then What d diference b/w two?

[ck9663]

Functions ia a block of code that performs some task & returns value.

Can somebody tell me What are Stored Procedures?
I found abt Stored procedues from the Net-->Stored Procedures is a group of SQL statements that form a logical unit and perform some task.

Above defintion of Stored procedures is same as functions.
Then What d diference b/w two?

Check here or here or here

-- CK