Call store procedure from function

Hi,

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

Thanks

FabioFabio (fabio.gagno@.gmail.com) writes:

Quote:

Originally Posted by

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx