Posted by Erland Sommarskog on 11/13/07 15:03

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]