Tag Archives: difference between function and stored procedure

Function Vs Stored Procedure

Difference between Function and Stored Procedure Functions Compiled and executed at Run time. Can not affect the Database state. i.e Can not perform insert,delete and update operation. Can return 1 value which is mandatory. Can have Input parameters only. Function … Continue reading

Posted in SQL | Tagged , , , , | Leave a comment