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
25 views
asked Mar 8, 2014 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 Mar 8, 2014 by smith Geek (15,340 points)

Related questions

0 votes
1 answer 21 views
0 votes
1 answer 34 views
34 views asked Jan 9, 2014 by keem Expert (13,240 points)
0 votes
1 answer 52 views
0 votes
1 answer 130 views
130 views asked Sep 9, 2011 by anonymous
0 votes
1 answer 20 views
...