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 the types of locks available in SQL Server?
There are lots of locks available in SQL Server.
-
What is a Filtered Index?
Filtered Index Filtered Indexes are one of the best
-
What do you used to write in the Stored procedure header ?
Stored procedure header plays a crucial role in providing the
Leave a Reply