Link to home
Start Free TrialLog in
Avatar of Tapan Pattanaik
Tapan PattanaikFlag for India

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 ?
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

No.  Only extended stored procedures.  You also cannot use dynamic SQL in a UDF.
Avatar of Tapan Pattanaik

ASKER


Can we use  stored procedure  inside a user defined function  in ms sql server?
ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.