Can any body explain me difference between stored procedures and UDF

I know that we can use UDF in select statement but we can't use stored procedures in select statements

awaiting reply
Thanks

UDF == User Defined Function

The difference is, a stored procedure runs some query, a UDF however is used to process some value and return some value. Think of a SUM() or AVG() function, and you get the idea.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

To add to that... pretty sure a function cannot have an UPDATE or INSERT into a table other than a table variable created within the function... and it can't return result sets or results of PRINT's. Stored procedures can. Functions cannot use Temp tables... stored prcedures can. Pretty sure that functions cannot execute stored procedures... stored procedures can. Can't use SET commands in functions either.

Actually it's easier to say what a function can do with the understanding that everything else can't be done in a funtion. To find that info, curl up with BOL looking for "Functions, User Defined" for the full skinny.

--Jeff Moden