Is it possible to call stored procedures inside a function

Question

Post reply

Is it possible to call stored procedures inside a function

vaibhav.a

Right there with Babe

Points: 719
More actions
December 26, 2008 at 6:35 am

#197790

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 🙂

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

Only extended stored procedures can be called inside a function.

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 2

http://msdn.microsoft.com/en-us/library/ms187440(SQL.90).aspx

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 3

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)