4. What is Difference between Function and Stored Procedure?

What is Difference between Function and Stored Procedure?

Answer

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.

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---