December 26, 2008 at 6:35 am
I want to call a stored procedure inside a function... and then create a view using that function . How can i use stored procedure inside a function....
Thank You 🙂
December 26, 2008 at 7:37 am
Only extended stored procedures can be called inside a function.
December 26, 2008 at 8:00 am
December 26, 2008 at 10:25 am
vaibhav.a (12/26/2008)
I want to call a stored procedure inside a function... and then create a view using that function . How can i use stored procedure inside a function....Thank You 🙂
Why??? What will you accomplish by even thinking about doing this?
Use OPENROWSET to create the view of the proc if you must... just remember that you will not be able to pass parameters to the stored procedure.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply