SP Calling SP

CREATE PROCEDURE [Owner.]ProcedureName [LANG = languagename]

[(ParameterName ParameterDataType

CREATE PROCEDURE [Owner.]ProcedureName [LANG = ProcLangName]

[(ParameterDeclaration [, ParameterDeclaration] [...])]

[WITH RESULT ResultDeclaration [, ResultDeclaration] [...]]

AS BEGIN

ProcedureStatement;

EXECUTE PROCEDURE [Owner.]ProcedureName

[(ActualParameter) [,...]]

where ActualParameter =

[ParameterName = ] ParamaterValue [OUTPUT [ONLY]]

[...] END ;

[IN DBEFileSetName]

Previous slide

Next slide

Back to first slide

View graphic version