Bueno ayer mi compañero me pidio si no sabia una forma de que desde un procedimiento almacenado se llame a otro procedimiento y este ultimo procedimiento retorne un valor. Buscando en internet encontre esto y funciona
You could use an OUTPUT parameter for this.
CREATE PROCEDURE inner_sp @x int OUTPUT AS
SELECT @x = 23
go
CREATE PROCEDURE outer_sp AS
DECLARE @x int
EXEC inner_sp @x OUTPUT
PRINT '@x is ' + ltrim(str(@x))
The trick is that you must specify OUTPUT when you call the procedure as
well.
http://bytes.com/groups/ms-sql/534626-how-get-sp-return-value-another-sp
You could use an OUTPUT parameter for this.
CREATE PROCEDURE inner_sp @x int OUTPUT AS
SELECT @x = 23
go
CREATE PROCEDURE outer_sp AS
DECLARE @x int
EXEC inner_sp @x OUTPUT
PRINT '@x is ' + ltrim(str(@x))
The trick is that you must specify OUTPUT when you call the procedure as
well.
http://bytes.com/groups/ms-sql/534626-how-get-sp-return-value-another-sp
Comentarios
Publicar un comentario