| urmi |
Posted: Sep 07, 2007 06:29:02 AM |
Total Post: 10
Joined: Jan, 2007
|
hi friends
If same problem can be solved with PROCEDURE and FUNCTION ,
Which option u will prefer ? i.e procedure or function .
if your answer is procedure.................why?
Function..................why? |
|
|
 Nehru |
| Posted: Sep 07, 2007 08:57:42 AM |  |
|
Total Post: 45
Joined: Jul, 2007
|
Hi,
Choosing of Solution way is depend on the requirement,
I Think every one do like this,
if we need return value then they can go to FUNCTIONS,Because Functions concept is that, if there is no return value then go for Procedures.
Any one let me Know if am wrong
Take Care
Bye
Nehru
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Sep 10, 2007 12:39:43 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
To add some more to that, I will go with fuctions if I need to do some calculation and return a value. If there is no return of value required or requirement is to return more than one value then i will go with procedure.
|
|
|
|
|
| Manu |
| Posted: Nov 19, 2007 12:18:53 AM | |
|
Total Post: 11
Joined: May, 2006
|
A function can be used inside a 'SELECT' statement and can be used as a column. But procedure want to execute explicitly.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
