What is the difference between a Stored procedure and function?
Answers were Sorted based on User's Feedback
Answer / sanjay das
Function allways returns value but stored procedure may or
may not return value.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / viren chakraborty
a stored procedure is better when returning one or more
rows.
a function is better when returning a single scalar value.
function and procedure, both can accept parameters and both
also support output parameters.
for programmers, stored procedures are the way to go
because they directly return the result of a given select
statment.
in a function you will explicitly have to return a value
using return statement and returning more than 1 value
using a function is much more complicated.
the procedure is capable of doing all kinds of things
(select/insert/update/delete) and hence, it is better
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / orknob ghosh
Stored procs can't be called within function but function
can be called within stored procedures.
Stored proc can have DML statements whereas a fuction can't
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pandian
1.Stored Procedure WE can call Independ using Exec
statement but function always depend on sql statement
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / preetam
Proceudure is pre Compiled Query but function is not
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhavi latha
stored procedute can return only one integer value.while
function can return more than one value.
we can not use select statement with storedprocedures like
select <spname> where as UDF can.
storedprocedures can not return tables.where as UDF can
return more than one tables.
we can use functions inside the stored procedure but in UDF
we can not use storedprocedures.
Is This Answer Correct ? | 2 Yes | 7 No |
Answer / ruchi aggarwal
1.Functions can be used in select, where or case statement
whereas sp cannot.
2.In Functions we cannot modify the base table information.
DML statements cannot be used.
3.In Function non deterministic funstions are not used
whereas we can use them in sps eg:GETDATE
4.No Multiple result sets can be returned from function
whereas we can do this in sp.
5.Error handling is restricted. RAISERROR and @@ERROR are
invalid from inside User Defined Functions
Is This Answer Correct ? | 0 Yes | 5 No |
Answer / kautilya
stored procedure can not take paramateres while function
can produce results as per the values passed to it and
functions returns value
Is This Answer Correct ? | 4 Yes | 10 No |
1.stored proceudures can not return tables whereas
functions can.
2.stored procedures can not used in select statemnet
whereas functions can.
Is This Answer Correct ? | 3 Yes | 9 No |
How does cookies work in asp net?
Please brief not about xsd,xslt & xml?
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
How can you handle unmanaged code exceptions in asp.net?
What is Stateless ASP or ASP.Net?
Why Web Services?
What is request and response in asp.net?
1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?
What is boxing and unboxing?
Explain weak typing and strong typing.
What are the different ways you would consider sending data across pages in ASP (i.e between asp to asp)?
What is the use of @Register directives?