Calling stored procedure in a function..

[ramnujs]

Can we call a stored procedure in a function and make the function return a table?

 

[priyanks]

If you use a table function, it will return a table.
For example:

create function MyFunction
returns @mytable table (Id int)
as begin
insert @mytable values(1)

return
end

I don't think you can call a storedprocedure in a function but you can always call a function in a stored procedure.