C Books Guide and List
C++ Books Guide and List
Best Java Books

3,749 questions

4,049 answers

114 comments

10,705 users

What is Difference between Function and Stored Procedure?

0 votes
26 views
asked by kelly johnes Advisor (6,330 points)

1 Answer

0 votes
 
UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be. UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables. Inline UDF's can be thought of as views that take parameters and can be used in JOINs and other Rowset operations.
 
answered by smith Geek (15,340 points)

Related questions

0 votes
1 answer 22 views
0 votes
1 answer 37 views
0 votes
1 answer 53 views
0 votes
1 answer 133 views
0 votes
1 answer 22 views
...