Re: Function VS StoredProcedure

From: songie D (songie_at_d.com)
Date: 05/21/04 

Date: Sat, 22 May 2004 00:06:20 +0100

You can say that again.

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:e817M%231PEHA.556@tk2msftngp13.phx.gbl...
> > But best of all a UDF call can be made as part of a SELECT statement,
> where
> > as you can't do this with a SP.
>
> "Best" if you really need it, "worst" if you care about performance (since
> typically this will execute the function for every row in the query). ;-)
>
>