Latest Answer: 1. A function is used to compute a value. A porucedure is used to execute business logic.2. A functin must return a value. A procedure may not return a value or may return more than one value using out parameter.3. A function can be called from DML statements ...
A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right
Latest Answer: Stored procedures are pre compiled SQL Statements. Stored procedures can remove the compilation overhead that is typically required in situations where software applications send inline SQL queries to a database. Stored procedures allow for business ...
View page << Previous 1 [2]
Go Top
