What is the impact of using a stored proc or a function on the performance? Which has a better performance? Also, why is it not possible to use DML in the functions called from a select query?

Nupur

• Apr 24th, 2015

Functions and procedures are both named blocks of statement . A function must return a value . Performance wise if you want the program to return a single value use a  function . You can use out par...

Suchith Shivali

• Apr 17th, 2015

1)In stored procedure you may or may not return value but in the function return is compulsory. 2)If you want to return more than one value go for Stored procedure. 3)Once SP or function is created,...

Answer Question  Select Best Answer