Stored Procedure Question:
Download Questions PDF

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

Answers:

Answer #1
A 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 #2
A stored procedure maintains the security of data base where as user defined function not.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
What are the uses of stored procedure?Explain about the implementation of stored procedures?