When do we use UDFs instead of Stored Procedures?
Since there are more advantages of Stored procedures over UDFs, most of us think that stored procedures are the best always. There should be some reasons why UDFs were introduced in DBMS.
Below are the scenarios in which we should use UDFs only.
- Can Join the UDF output with another table. But we can’t write SELECT statements with Stored Procedures.
- Can call UDF in WHERE/HAVING clauses.
Happy Reading 
-
What are Sparse columns and when do we need it?
Sparse Columns: Sparse columns are very much useful while
-
What are SQL aggregate functions and explain few aggregate functions which you have used real time?
SQL Aggregate functions are the functions which perform calculations
-
What are the Properties of Sub-queries?
Properties: We can use Order by only when we
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply