What is Difference between Function and Stored Procedure?

What is Difference between Function and Stored Procedure?

Many Difference are there :> UDF can be used WHERE/HAVING/SELECT sectionanywhere in the SQL statements, But in case ofStored procedures cannot be. > UDF\'s that return tables can be treated asanother rowset. This can be used in JOINs withother tables. Inline UDF\'s can be thought of asviews that take parameters and can be used inJOINs and other Rowset operations.

By:UMANG
Date:2010-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher