User Defined Function
Why can't we call Stored Procedure from UDF??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vikram AgrawalPosted Feb 9, 2015, 10:46 PM
Hi Pramod,
As we know we can not perform any DDL,DML operation inside a function except Select and also we can not use any error handling & transactions inside this. But we can do all these operations inside Stored Procedure. So if we call any SP inside UDF then there are chances for occurring all these operations.
That is why sql not allows us to call any SP inside UDF
Thanks