Stored Procedure Question: Download Stored Procedure PDF

What is the difference between a user defined function and a Stored procedure?

Tweet Share WhatsApp

Answers:

Answer #1A user defined function and stored procedures are almost similar but there exists a difference between their implementation procedures in the code. Stored procedure needs to be invoked whereas a UDF can be used like any other statement.

Answer #2A stored procedure maintains the security of data base where as user defined function not.

Download Stored Procedure PDF Read All 17 Stored Procedure Questions
Previous QuestionNext Question
What are the uses of stored procedure?Explain about the implementation of stored procedures?