function vs storedprocedure

Question

what we cannot use stored procedure inside a function?

Ben Chris · Answer

Store procedures can return multiple designated information while the very essence of the functions is to return a single information. So you can use functions inside store procedures but you can only use store procedures inside a function if the result of a store procedure is not effecting the output of the function which is single in nature.

Pravat Kumar · Answer

Hi Sushil Kumar No we can't create a function with stored procedure inside it

Daniel Jones · Answer

Take a look at this link hope this will help you out: http://stackoverflow.com/questions/2896445/why-can-we-not-execute-a-stored-procedure-inside-a-function-in-sql-server-2005

Suvendu Shekhar Giri · Answer

Yes. You can use a function inside a stored procedure but before all that can you let us know what is your requirement?