Call store procedure from function

Hi,

is there any method to call a store procedure into a function?

Thanks

Fabio

Re: Call store procedure from function

Fabio (fabio.gagno@gmail.com) writes:
> is there any method to call a store procedure into a function?

No, you cannot call stored procedures from function. Functions must not
change database state. Overall, functions are intended for a fairly
limited use, and if you find that you need to call a stored procedure
from your function, you should probably write a stored procedure instead.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx