Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create a stored procedure within another stored procedure in SQL Server 2008

I want to create a stored procedure to be used within a stored procedure something like shown below. Is this possible?

CREATE procedure parentSP
as 

--child SP definition.
CREATE procedure childSP1 @inputArg varchar(50)
as 
--do something.
Go

--call child sp within parentSP
execute childSP1 '10'

Go
like image 492
sqlnewbie Avatar asked Jun 23 '11 06:06

sqlnewbie


1 Answers

You can use exec:

CREATE procedure parentSP
as 
exec('CREATE procedure childSP1 @inputArg varchar(50)
as 
--do something.')

--call child sp within parentSP
execute childSP1 '10'
Go
like image 80
Adam Ruth Avatar answered Oct 02 '22 17:10

Adam Ruth