Tapan Pattanaik
asked on
Can we execute stored procedure inside a user defined function in ms sql server?
Can we execute stored procedure inside a user defined function in ms sql server?
if yes, then can u give an example? is there any adverse effect ?
if yes, then can u give an example? is there any adverse effect ?
No. Only extended stored procedures. You also cannot use dynamic SQL in a UDF.
ASKER
Can we use stored procedure inside a user defined function in ms sql server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
While you may not have gotten the answer you desired, it is 100% correct and a B is not an appropriate answer. I would ask that you "request attention" and have the grade changed. Request Attention can be found in your original post.