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 is the foreign key constraint and what is the need of it on a Table?
Foreign key Foreign key is a field or combination
-
What are the different ways of transferring data from one database to another database?
There are several ways available to transfer the data
-
What are the Constraints and list the available constraints in SQL
Constraint: SQL Constraints are the rules created on tables
Leave a Reply