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

Question

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.

Jignesh Trivedi · Answer

Hi As per my knowledgeyou can not call sp from functions. please refer. http://searchsqlserver.techtarget.com/tip/Stored-procedures-vs-functions

Chintan Rathod · Answer

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.