Differences between functions and stored procedures?
- 8 Answers
- 14031 Views
- 247Customer, Accenture, I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
1. Functions are compiled and executed at run time.
Stored procedures are stored in parsed and compiled format in the database(Pree compiled).
2. Functions cannot affect the state of the database which means we cannot perform insert,delete,update and create operations on the database.
Stored Procedures can affect the state of the database by using insert,delete,update and create operations.
3 Functions are basically used to compute values. We passes some parameters to functions as input and then it performs some operations on the parameter and return output.
Stored procedures are basically used to process the task.
4.Function can not change server environment and our operating system environment.
Stored procedures can change server environment and our operating system environment.
5.Functions can invoked from SQL Statements.
example : select udf from table name
Stored procedures can't invoked from SQL staements.
example : select spname from table name
6.Functions can run an executable file from SQL SELECT or an action query.
operating system use Execute or Exec to run
7.We can use User Defined function in Stored procedure
we can't use stored procedure in UDF.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
List the types of recovery model available in sql server?
What are SSL and TSL protocols?
Do you know what is a with(nolock)?
Can group functions be mixed with non-group selection fields in ms sql server?
How many categories of functions based their return modes?
What are system databases into sql server (2005/2008) : sql server database administration
Explain log shipping?
How extra digits are handled with numeric data type literals?
Can we use where and having clause together?
Can two tables have the same primary key?
What is difference between materialized view and view?
What functions can a view be used to performed?
Why would you call update statistics?
What does it mean to normalize a database and why would you do it?
what data regions are and what are the different data regions?
