function vs storedprocedure

Pravat Kumar9y ago

Hi Sushil Kumar,

No, we can't create a function with stored procedure inside it

+1

Daniel Jones9y ago

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

+1

Asma Khalid9y ago

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.

+2

Suvendu Shekhar Giri9y ago

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

0