Can I do that because it call from function if i use a normal form such as xxx() in mysql? please show me how to do it,thx.
-
Which RDBMS are you using? Stored procedure capabilities are RDBMS-specific.Brian Clapper– Brian Clapper2011-01-16 18:11:24 +00:00Commented Jan 16, 2011 at 18:11
Add a comment
|
2 Answers
In SQL Server it is plain vanilla exec proc statement, here is sql server syntax
create procedure prYourProc
as
-- exec other proc
exec prSomeOtherProc
-- to get return value
declare @var int
exec @var = prSomeOtherProc
Comments
PROCEDURE 1
DROP PROCEDURE IF EXISTS Proc1;
CREATE PROCEDURE Proc1()
BEGIN
CALL Proc2();
END
PROCEDURE 2
DROP PROCEDURE IF EXISTS Proc2;
CREATE PROCEDURE Proc2()
BEGIN
SELECT ColumnName FROM table2;
END
Comments
