Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Difference between Stored Procedure and User Defined Function ?

April 26, 2017defined difference function procedure stored user

0

Posted

Difference between Stored Procedure and User Defined Function ?

1 Answer

0

Posted

UDF and STored Procedure UDF : Excutable from SQL,SELECT and SQL action queries SP :Use EXECUTE or EXEC to run UDF : Doesnt return output parameters SP : Supports output parameters UDF : Returns table variable SP : Can create a physical table and populate it, but cant return a table variable UDF : Can join to a UDF SP : Cant join to a SP UDF : Cant make permanent changes to the server environment or an external source SP : SP can be used to change some of the server environment and operiting environment UDF : Cant be used in an XML FOR clause SP : Can be used in an XML FOR clause UDF : T-SQL errors stops the function when an error occurs SP : Errors are ignored and T-SQL processes the next statement.