我想创建一个存储过程,以便在另一个存储过程中使用,类似于下面所示的方式。这是否可能?
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
我想创建一个存储过程,以便在另一个存储过程中使用,类似于下面所示的方式。这是否可能?
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
你可以使用exec函数:
CREATE procedure parentSP
as
exec('CREATE procedure childSP1 @inputArg varchar(50)
as
--do something.')
--call child sp within parentSP
execute childSP1 '10'
Go