diffrence between function and procedure

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / katta_s

5 Answers
5847 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

diffrence between function and procedure..

Answer / srinivas k

Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.

Is This Answer Correct ?

5 Yes

0 No

diffrence between function and procedure..

Answer / sakthi

Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences

Is This Answer Correct ?

3 Yes

0 No

diffrence between function and procedure..

Answer / pradeep aryan

1. Function can returtn single value but proc san return
multiple values

2. Proc can call a function but function not.

3. function can call in select statement also and acn perform
action also but proc not.

Is This Answer Correct ?

3 Yes

0 No

diffrence between function and procedure..

Answer / jayanth

Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values

Is This Answer Correct ?

0 Yes

0 No

diffrence between function and procedure..

Answer / rakesh

function always return value, and procedure not Return the value.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer