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

• Next in forum: Re: Why is SQL Server 2005 Express on my PC and why won't it update?
• Prev in forum: Why is SQL Server 2005 Express on my PC and why won't it update?
• Thread view: Re: Call store procedure from function

[Reply to this message]