|
|
Posted by Hugo Kornelis on 10/15/06 22:03
On 15 Oct 2006 11:37:32 -0700, shark wrote:
(snip)
>Thanks Hugo . but then what id functiond do have an execution plan wht
>are the advantages of using them over stored procedures.
Hi Shark,
User-defined functions and stored procedures are used in so different
situations and have such different properties that the choice which one
to use is made based upon how it will be used, not whether an execution
plan gets generated.
I don't know of any situations where you could easily change a stored
procedure to a function or vice versa.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|