Difference between Function and Stored Procedure?
Answer Posted / mohammad sajid
Although both functions and sp's are prcomiled sql
statements there exists some differences between them.
1. Functions must return a value(scalar,inline table or
multi statement table) whereas stored proc may or may not
retun a value.
2.Functions can return a table whereas stored procs can
create a table but can't return table.
3. Stored procs can be called independently using exec
keyword whereas function are called using select statements.
4. Stored procs can be used to change server configuration
(in terms of security-i.e. setting granular permissions of
user rights) whereas function can't be used for this
5. XML and output parameters can't be passed to functions
whereas it can be with sp's.
6.transaction related statement can be handled in sp
whereas it can't be in function.
7. stored procedures can call a funtion or another sstored
proc similarly a function can call another function and a
stored proc.The catch with function is that no user defined
stored proc can be called.Only extended/system defined
procs can be called.
Hope this will be helpful and if there's any correction let
me know.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is nonclustered index with included columns ?
What are the two modes of authentication in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is postgresql server?
How to find Duplicate Records In table?
what exactly sql injuction.how to overcome.....
What is it’s similarity with sql server?
Can we update data in a view?
How connect excel to sql server?
What happens if null values are involved in datetime operations?
What is the difference between update lock and exclusive lock?
Explain transaction server isolation?
can we have a nested transaction? : Sql server database administration
What is meant by datasource?
What Are the Main Features of SQL Azure?