Call store procedure from function

#1

Hi,

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

Thanks

Fabio

#2

Fabio (fabio.gagno (AT) gmail (DOT) com) writes:

Quote:

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Call store procedure from function

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Call store procedure from function - 11-13-2007 , 05:01 AM

Re: Call store procedure from function - 11-13-2007 , 09:03 AM