Loading

How to call a UDP sproc in function using sql server 2008

Aarti

14y2.8k

Hi ,

How to call a sproc in user defined function in sql server 2008..
my sproc is also creating temp table inside it , so is it possible call this sproc in user defined function..
I googled but did not get.

Thanks in Advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
Hi,

As per my knowledge,you can not call sp from functions.
please refer.

http://searchsqlserver.techtarget.com/tip/Stored-procedures-vs-functions
Chintan Rathod14y ago
You cannot change the database state inside a function so calling a stored procedure from a function is prohibited by design.

Truly saying, this 'limitation' can be bypassed using for example OPENQUERY. For more information, see:

http://msdn.microsoft.com/en-us/library/aa175782%28v=sql.80%29.aspx

Thank You.